Hp Neoview Release 2.4 Software Bedienungsanleitung PDF herunterladen (Seite 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

1 2 ... 38 39 40 41 42 43 44 45 46 47 48 ... 123 124

Kommentare zu diesen Handbüchern

Keine Kommentare

Hp Neoview Release 2.4 Software Bedienungsanleitung Seite 43

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software Hp Neoview Release 2.4 Software