HP Neoview Release 2.5 Software - Manual (Page 75)

8 Data Processing
This chapter addresses these topics:
“Data For Load Operations” (page 75)
“Processing Data for Load Operations” (page 75)
“Delimited Data” (page 76)
“Considerations for Character Data” (page 78)
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
Description Type 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 61) 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 37) clause optionally qualified by is specified and the
first character is the quoting character, perform quote processing. See “Quote Processing
For Load Operations” (page 77) .
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 53) 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 53) file.
7. Process remaining characters as appropriate for the target data type. If a field cannot be
processed according to the specified
“Typeformats” (page 31) rules, reject the record and
write it to the “baddatafile” (page 53) file.
Data For Load Operations 75