Hp Neoview Release 2.4 Software Manuel d'utilisateur télécharger pdf (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

“crossoveryear” (page 49)

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

1 2 ... 31 32 33 34 35 36 37 38 39 40 41 ... 123 124

Commentaires sur ces manuels

Pas de commentaire

Hp Neoview Release 2.4 Software Manuel d'utilisateur Page 36

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Hp Neoview Release 2.4 Software