HP Neoview Release 2.5 Software - Manual (Page 39)

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 39