HP Neoview Release 2.4 Software - Manual (Page 43)

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.
sourcename file filename [options source-options]
Specifies a data file as the data source/target. filename specifies the location of the file,
including both the path and the file name.
Transporter assumes the data file is uncompressed.
Example:
Specify a plain data file, datafile_1.dat, in the current directory with source name
data1
:
data1 file "./datafile_1.dat"
Control File Organization and Syntax 43