HP Neoview Release 2.3 Software User Manual
Page 33

Dataformats: Delimited Format
formatname delimited
[options format-options]
[fields delimited by character]
[records separated by character]
[optionally qualified by character]
field-definitions
format-options
(
option_name = option_value [, option_name = option_value ]...
)
formatname
The name you choose for this dataformat. The name must be unique within the dataformats
namespace. formatname is case-insensitive and cannot exceed 64 bytes.
options format-options
fields delimited by character
defines the character separating each data field.
For information, see
“Field Delimiter Character” (page 64)
records separated by <nl> [ <nl> ...]
Defines the character sequence separating each data record. The only allowed record separator
is one or more <nl>'s.
For information, see
“Record Separator Character ” (page 64)
.
optionally qualified by {' | "}
Specifies a quoting character for each data field.
For information, see
“Quote Processing For Load Operations” (page 65)
field-definitions
See
Dataformats: Field Definitions for Source and Target (page 34)
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 choose for this dataformat. The name must be unique among existing
dataformats namespace. formatname is case-insensitive and cannot exceed 64 bytes.
Control File Organization and Syntax
33