Hp Neoview Release 2.4 Software Manual de usuario descargar pdf (Pagina 37)

Dataformats: Neoview SQL Table Format

formatname sql fields

fields-definition

formatname

The name you create for this delimited dataformat. The name must be unique among existing

dataformats.

Dataformats: Field Definitions for Source and Target

field-definitions:

(

field-definition [, field-definition ]...

)

field-definition:

fieldname datatype

[format formatname] [options field-options]

field-options

(

option_name = option_value [, option_name = option_value ]...

)

field-definition

One or more occurrences of field-definition, separated by a comma (,). The last

field-definition should not use the comma separator.

fieldname

The name you select for the field of the format. If the format is SQL table, the fieldname

must be one of the column names of the associated SQL table or query. Otherwise, the

fieldname must be unique within this record format.

When a Neoview SQL table format is used for an extract operation, the following rules

and considerations apply:

• For table sources, fieldname must be one of the column names of the associated

table.

• For Neoview SQL sources (where the extract source is a database query):

— fieldname must be one of the 1-part column names of the associated query.

That is, fieldname must be a simple column name only without any table

qualifier. For example, for a column named ADDRESS from a table named

EMPLOYEES:

fieldname must have the value: ADDRESS

fieldname cannot have the value: EMPLOYEES.ADDRESS

• If multiple columns of the query have names matching fieldname, the

field-definitions is assumed to refer only to the first column position where

Control File Organization and Syntax 37

1 2 ... 32 33 34 35 36 37 38 39 40 41 42 ... 123 124

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 37