Datatype mappings – HP Neoview Release 2.4 Software User Manual

Page 40

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

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 character type
date

timestamp

date

any character type
time

timestamp

time

Control File Organization and Syntax