Neoview Database Administrator's Guide (R2.2)

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.
For example, if you specify these formats:
dateFormat = MMDDYY
dateSeparator = -
crossoverYear = 50
then input date:
12-15-50
is stored as:
12-15-1950
and input date:
12-15-06
is stored as
12-15-2006
Times
Times use this fixed format:
hh:mm:ss.ffff
Time fields cannot be enclosed in quotes.
Timestamps
The date portion of a timestamp field follows the same rules as dates. The time portion follows
the same rule as times.
Suppose you specify the date format as MMDDYYYY and dateSeparator as the slash ("/")
character. The timestamp is specified as TIMESTAMP(2) in the target table. The timestamp to
be entered is 9:00AM on July 27, 2006. The input would be:
07/23/2006 09:00:00.00
Timestamp fields cannot be enclosed in quotes.
Intervals
Interval data types are not supported.
Nulls
There are two ways to represent null characters:
• By specifying no characters for a field, which results in two delimiter characters being
adjacent in the input.
• If a field contains all blank characters and is not enclosed in double quotes, and if the
rightTrim option is set to Y (the default), that field is also treated as a null value because
trailing blanks are removed on input. These two sample input records have null values for
the second field:
VALLCO,,95014
VALLCO, ,95014
If the column being loaded with this value is not defined as NULLABLE, the record will be
rejected.
Character Sets
You can load data into character fields without the Neoview Loader performing any character
set conversion on the input data. Previously, all input data had to be provided in UTF-8 format,
and character data was converted to either ISO8859-1 or UCS-2 format depending on the character
102 Using the Neoview Loader