HP Neoview Release 2.3 Software User Manual
Page 34
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 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