Databases Reference
In-Depth Information
In a fixed record format, the control file specifies the
column
name
(
A
), the physical
position of the column in the file, starting to count with the column 1 and specified
by the keyword
POSITION
(
B
), and the specific
data
type
(
C
).
It is important to point out that the date format specified at the control file assumes
the data file matches the default date format, according to the configured locale. If
this condition is not met, then a malformed date format error will be shown and
the load is very likely to be aborted due to the maximum defective row limit. If a
different format is specified at the data file, then a date mask must be specified next
to the
DATE
type declaration.
HIREDATE POSITION(32:40) DATE "DD-MON-RR"
Once this initial fixed field size is executed, the log file will read as follows:
Search WWH ::
Custom Search