Hp Neoview Release 2.4 Software Manual de usuario descargar pdf (Pagina 69)

8 Data Processing

This chapter addresses these topics:

“Data For Load Operations” (page 69)

“Processing Data for Load Operations” (page 69)

“Delimited Data” (page 70)

“Considerations for Character Data” (page 72)

Data For Load Operations

This section addresses how Transporter processes data for a load operation, and how it treats

delimited and fixed-width data.

Table 8-1 Delimited and Fixed-width Data Descriptions

DescriptionType of Input Data

Fields are separated by delimiter characters.

You specify a delimiter character in the control file.

The default character is the comma (,).

Delimited Data

The width of each field in a record is the same across all records.

You enter the data as text, without quotes.

Records are separated by the system EOL ('\n') , or a sequence of them.

Fixed-Width Data

Processing Data for Load Operations

This section describes how Transporter addresses and processes the data for load jobs.

Delimited Data for Load Operations

Transporter addresses and processes a delimited input field as follows, in this order:

1. Transporter considers the following to be a NULL value: An input field of zero length before

white space trimming or quote processing is performed.

2. Trim leading and trailing white space characters. This does not involve characters inside

double quotes. (“)

3. If “nullstring” (page 56) is specified, determine whether the input field matches the

nullstring value. If it matches, the input is considered a NULL value.

4. If the “Dataformats” (page 35) clause optionally qualified by is specified and the

first character is the quoting character, perform quote processing. See “Quote Processing

For Load Operations” (page 71).

5. If the target data type is a character type, truncate any characters beyond the field length

that Neoview SQL expects for the column or SQL expression. If any of the truncated characters

are not white space, reject the record and write it to the “baddatafile” (page 49) file.

6. If no characters remain in the input field:

a. if the target data type is a character type, consider the value as an empty string.

b. if the target data type is a type other than a character type, reject the record and write

it to the “baddatafile” (page 49) file.

7. Process remaining characters as appropriate for the target data type. If a field cannot be

processed according to the specified “Typeformats” (page 29) rules, reject the record and

write it to the “baddatafile” (page 49) file.

Data For Load Operations 69

1 2 ... 64 65 66 67 68 69 70 71 72 73 74 ... 123 124

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 69

Comentarios a estos manuales

Relacionado con productos y manuales para Software Hp Neoview Release 2.4 Software