
options format-options
“crossoveryear” (page 47)
record-length number
Specifies the length of a data record in unit of characters.
For example, each record is 256 characters:
record length 256
Dataformats: Fixed Field Definitions
The fixed-field-definitions list defines the offset for each data field in order. It begins
with keyword fields positions followed by a parenthesized list of offsets in units of characters.
Offsets are 1–based, meaning the first character of a record is at position 1. Offsets are separated
by commas.
These additional rules apply:
• Offsets must be listed in increasing order.
• The first offset can be greater than or equal to one.
• No two offsets can be equal.
field-definitions
See Dataformats: Field Definitions for Source and Target (page 34).
fields positions
(
field1_offset,
field2_offset,
...
fieldn_offset
)
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.
34 Control File Organization and Syntax
Comentários a estes Manuais