Neoview Database Administrator's Guide (R2.2)

set defined for the target column. The cSetConversion (-cc) argument allows you to specify that
no character set conversion should be applied for this load task.
This feature is useful when you want to load data, such as SHIFT-JIS, into a table, but do not
want to convert the SHIFT-JIS data to UTF-8 format before loading. When you use this feature
with delimited input where the input data is multibyte (e.g. SHIFT-JIS) take care to ensure that
the delimiter character cannot show up as part of the regular input data. If you are loading
SHIFT-JIS data, the delimiter character must be less than hexadecimal 0x40. Where the target
column is a CHAR, the input data will be blank padded with the space character (0x20) when
the data is actually loaded into the target table.
Fixed-Width Input Data
For fixed-width input, you must specify a format file. All input data is entered as text, without
the quotes. For details on format files see “Using a Format File” (page 105).
Data Formats
Following are guidelines for formatting fixed-width input data:
Character fields
Enter character fields as straight text, without quotes. They can include any valid characters as
defined for the character set for the target column. Character fields’ trailing blank characters are
removed during input processing. For CHAR fields, the target column is padded with trailing
blanks if the input field has fewer characters than the target column.
Numerics
Numeric input must consist of only numerical values, including a leading sign character. The
decimal portion is identified using the period ('.') character and must be followed by at least one
digit. These are all valid numeric inputs for a column defined as NUMERIC (9,2) SIGNED:
+999.63
999.63
-123.01
When you specify the field length for a numeric field in the format file, the length of the field
must take into account any leading sign character and the decimal point. Any leading or trailing
blanks will be trimmed before processing a numeric value.
Integers
Integer input must consist of integer values with an optional leading sign character, depending
on whether the target column is SIGNED (plus or minus allowed) or UNSIGNED (plus allowed).
When you specify the field length for an integer field in the format file, the length of the field
must take into account any leading sign character. Any leading or trailing blanks will be trimmed
before processing an integer value.
Dates
You can specify the format for a date field as part of a task configuration with the dateFormat
(-df) and dateSeparator (-ds) arguments. You can also specify the format for a date field with a
format file.
When you specify the field length for a date field in the format file, the length of the field must
take into account the date separator character. Any leading or trailing blanks will be trimmed
before processing a date value.
If you use one of the two-digit year formats, the loader automatically adds the century, depending
on the value specified for crossoverYear (-cy). This argument specifies the year at which
the century changes from 19 to 20. For example, if crossoverYear is set to 50, all years whose
value is greater than or equal to 50 will have the century set to 19, and all years whose value is
less than 50 will be set to 20.
Input Data Considerations For Load Tasks 103