Neoview Database Administrator's Guide (R2.2)

For example, if you specify these formats:
dateFormat = MMDDYY
dateSeparator = -
crossoverYear = 50
Input date:
12-15-50
is stored as:
12-15-1950
Input date:
12-15-06
is stored as
12-15-2006
Times
Times use this fixed format:
hh:mm:ss.ffff
Timestamp
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 the 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
When you specify the field length for a timestamp or time field in the format file, the length of
the field must take into account the date separator character and the characters used for separating
the components of the time. Any leading or trailing blanks will be trimmed before processing a
date value.
Intervals
Interval data types are not supported.
Nulls
A null value is represented by the nullChar character in the format file. When you specify a null
value the input field must be contain all blanks with the exception of the null character that must
be the first character in the input field. For details on format files see “Using a Format File”
(page 105).
For example, if the nullChar is set to question mark "?" in the format file, these would all represent
a null value using this format file:
<layout nullChar="?"
<field name="FIELD1" ignore="false" startPos="1" length="3" />
<field name="FIELD2" ignore="false" startPos="4" length="3" />
<field name="FIELD3" ignore="false" startPos="7" length="3"
</layout>
If the column being loaded with this value is not defined as NULLABLE, the record will be
rejected.
Input:
ABC? DEF
104 Using the Neoview Loader