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
Defines the character sequence separating each data record. The only allowed record separator
is one or more
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