HP Neoview Release 2.4 Software User Manual
Page 36
optionally qualified by {' | "}
Specifies a quoting character for each data field.
For information, see
“Quote Processing For Load Operations” (page 71)
field-definitions
See
Dataformats: Field Definitions for Source and Target (page 37)
Dataformats: Fixed Length Format
In a fixed-length record file, the width of each field in the record is consistent across all records.
Records are separated by one or more system EOL characters.
formatname fixed
[options format-options]
record length number
fixed-field-definitions
field-definitions
format-options
(
option_name = option_value [, option_name = option_value ]...
)
formatname
The name you create for this dataformat. The name must be unique among existing
dataformats namespace. formatname is case-insensitive and cannot exceed 64 bytes.
options format-options
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 37)
fields positions
(
field1_offset,
field2_offset,
...
fieldn_offset
)
36
Control File Organization and Syntax