HP Neoview Release 2.3 Software - Manual (Page 39)

discussion of the condition option below for more detail. This option is not
supported for extract operations.
•
system — the Neoview system generates the key
• loader — the loader generator is used
Example:
EMP_ID = identity loader
Asks the loader to generate a key for target field EMP_ID.
scalar-expression
A simple expression composed of a fieldname_source, constant, and SQL functions
connected by simple arithmetic operators. This expression must be syntactically valid
for fitting into a corresponding SQL insert, update, or upsert statement. The maximum
length of a scalar-expression is 256 characters. This option is not supported for
extract operations and is not allowed on primary key columns.
field-source-ref
For an extract operation, field-source-ref must be one of the following:
•
fieldname-source (without the add or subtract option)
• NULL
• constant
field-mapping-options
A list of options.
condition = “true” | “false”
This option is only applicable for load operations where the operation type is update or
upsert. If condition is true, this field becomes part of the conditions in the WHERE
clause of the generated SQL statement.
This option is not allowed for an identity field mapping.
The default is “false” for non-key columns and “true” for key columns.
update = “true” | “false”
This option is only applicable for load operations where the operation type is update or
upsert. If update is true, this field becomes part of the UPDATE clause of the generated
SQL statement
This option cannot be set to “true” for primary key columns.
The default is “false” for key columns and “true” for non-key columns.
The condition and update options are ignored for insert operations.
The condition and update options cannot both be “true” for a field mapping unless it is a
reflexive update field mapping.
Examples of Field Mapping
• Assigns source field FIRST_NAME to target field FIRSTNAME:
FIRSTNAME = FIRST_NAME
• Adds the value of source field VALUE_SOURCE to the current value of target field
VALUE_TARGET
:
VALUE_TARGET = VALUE_SOURCE add
• Assigns NULL to the target field INFO:
INFO = NULL
• Assigns a constant string"N/A" to the target field INFO:
INFO = constant "N/A"
• Asks Transporter to generate unique key values for the target field EMP_ID:
Control File Organization and Syntax 39