Neoview Database Administrator's Guide (R2.2)

the result will be a NULL input value. Use the rightTrim(-tm)argument to prevent the trimming
of trailing blanks. Setting this argument to N means that all blank characters are retained. If the
input field contains double quote characters you must enclose the input for that field in double
quotes, and any embedded double quote characters must be preceded by another double quote
character. For example, to enter the string 17” monitor, submit it as:
“17”” monitor”
Character field examples
• A field that does not need to be enclosed in quotes:
Input string: 19333 VALLCO PARKWAY
Field input: 19333 VALLCO PARKWAY
• A field that contains all blank characters must either be enclosed in double quotes, or you
must specify the rightTrim(-tm) argument, set to N:
Input string (all blank characters): ' '
Field input: " "
• A field that contains double quotes must be preceded by another double quote character:
Input string: 19333 "VALLCO"
Field input: “19333 ""VALLCO"“
• A field that contains the field delimiter character (a comma) must be enclosed in quotes:
Input string: 19333 VALLCO, CUPERTINO
Field input: "19333 VALLCO, CUPERTINO"
Numerics
Numeric input must consist of only numerical values, including a sign character, and cannot be
enclosed in quotes. 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
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).
These are all valid inputs for a column defined as INTEGER SIGNED:
+999
999
-999
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. For a description of the format file, see “Using a Format File” (page 105).
Date fields cannot be enclosed in quotes.
Suppose you specify the dateFormat as MMDDYYYY and the dateSeparator as the slash ("/")
character. This is a valid date:
07/23/2006
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
Input Data Considerations For Load Tasks 101