HP Neoview Release 2.3 Software - Manual (Page 37)

targetformat
The target dataformat as defined in “Dataformats” (page 32) .
For a load operation, targetformat must be an SQL table dataformat.
For an extract operation, targetformat can be delimited or fixed-length dataformat.
field-mapping-definition
One or more occurrences of field-mapping-definition, separated by a comma (,). The
last field-mapping-definition should not use the comma separator.
fieldname_target, fieldname_source
fieldname_target and fieldname_source must refer to names defined in the source
dataformat and target dataformat, respectively. For more information about dataformats,
refer to
“Dataformats” (page 32) .
For a simple mapping, where the source field and target field are the same and there are
no specific map functions required (for example, expressions and identity columns),
field-source-ref
can be omitted.
If a field defined in the target dataformat is missing from the map’s field-mappings
section:
For a load operation, Transporter does not include the missing field in any SQL operations.
For a load operation, the following rules apply:
•
A field-mapping-definition must be specified for all primary key columns.
• If a field-mapping-definition is omitted for a non-primary key column, no
changes are applied to that column when updating rows and the SQL default value
is used for that column when inserting a new row.
For an extract operation where the target format is delimited, Transporter does not include
the missing field in the output records.
For an extract operation where the target format is fixed-length, Transporter includes the
missing field in all output records and its value always consists entirely of space characters.
fieldname_source_ref
For an extract operation, fieldname_source_ref must be one of the following:
•
fieldname_source without the add or subtract option
• NULL
• constant
fieldname_source_ref can be of one of the following forms:
fieldname_source
Data from this field of the source is assigned to the fieldname_target field of the
target.
This table lists the acceptable datatype mappings:
Table 5-3 Datatype Mappings
Can be Mapped to a Target Field of Type... Source Field of Type...
any type any character type
any character type
any integral type
any floating-point type
any integral type
any character type
any integral type
any floating-point type
any floating-point type
Control File Organization and Syntax 37