HP Neoview Release 2.5 Software - Manual (Page 42)

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 37) .
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
any character type
date
timestamp
date
any character type
time
timestamp
time
42 Control File Organization and Syntax