HP Neoview Release 2.5 Software - Manual (Page 43)

Table 5-3 Datatype Mappings (continued)
Can be Mapped to a Target Field of Type... Source Field of Type...
any character type
date
time
timestamp
timestamp
interval 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. You cannot specify NULL for all fields; Transporter returns
an error.
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 have condition set to true for update, insert, or delete
operations – Transporter returns an error. See the condition option for more detail.
This option is not supported for extract operations.
•
system — the Neoview system generates the key
• loader — the loader generator is used
Control File Organization and Syntax 43