Hp Neoview Release 2.3 Software Manual de usuario descargar pdf (Pagina 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

1 2 ... 34 35 36 37 38 39 40 41 42 43 44 ... 109 110

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.3 Software Manual de usuario Pagina 39

Comentarios a estos manuales

Relacionado con productos y manuales para Software Hp Neoview Release 2.3 Software