HP Neoview Release 2.5 Software - Manual (Page 45)

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 if the operation is upsert.
Transporter returns an error.
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:
EMP_ID = identity loader
• Increments the source field VALUE_SOURCE by 10 and assigns the resulting value to the
target field VALUE_TARGET:
VALUE_TARGET = expression ":VALUE_SOURCE + 10"
Sources
The sources section describes the location of data source and target, and their provider options.
sources
{
source-definition [, source-definition ]...
}
source-definition:
specific-source [, options source-options ]
specific-source
sourcename file filename |
sourcename pipe pipename |
sourcename {jdbc} {sql sqltext|table tablename} |
sourcename jms jmsname
source-definition
One or more occurrences of source-definition, separated by a comma (,). The last
source-definition
should not use the comma separator.
sourcename
A name you create for the source. The name must be unique within the sources namespace.
sourcename
is case-insensitive and cannot exceed 64 bytes.
Control File Organization and Syntax 45