HP Neoview Release 2.3 Software User Manual

Page 38

Table 5-3 Datatype Mappings (continued)

Can be Mapped to a Target Field of Type...

Source Field of Type...

any character type
date

timestamp

date

any character type
time

timestamp

time

any character type
date

time

timestamp

interval

For interval mappings, both fieldname_source and fieldname_target must
have an associated typeformat. Both typeformats must either be year-month, or
day-time ranges.

[add | subtract]

are used for reflexive update and apply only to update and upsert operations. When
the job operation is “insert” and one of these options is specified, the operation
becomes “upsert”.

These options are not supported for extract operations.

These options are not allowed on primary key columns.

If add or subtract is specified, the new value of the target field is:

old value of the target field +/- value of the source field

These options are only valid for integral data types.

NULL

A NULL value goes in the target field. For load operations, NULL is not allowed on
primary key columns.

Example:

INFO = NULL

assigns NULL to the target field called INFO.

default

The default value for the column of table is used at loading. This applies when the
target format is an SQL table format. This option is not allowed on primary key
columns and is not supported for extract operations.

constant constant_value

constant means the constant_value goes to the assigned target field.
Encloseconstant_value in double quotes ("").

Example:

INFO = constant "N/A"

assigns the string “N/A” to the target field INFO.

identity (system | loader)

A keyword to specify that the target field takes on a unique value in each record. The
unique values are generated by Transporter. The only option supported is loader. If
system is specified, Transporter acts as though loader is specified. identity map
entries cannot be used as condition fields for update and upsert operations. See the

Control File Organization and Syntax