Table Information

• table name

• load conditions, if any. That is, whether all record were loaded or only those meeting WHEN-clause criteria.

• INSERT, APPEND, or REPLACE specification

• the following column information:

• if found in data file, the position, length, datatype, and delimiter

• if specified, RECNUM, SEQUENCE, or CONSTANT

• if specified, DEFAULTIF, or NULLIF

Table EMP, loaded from every logical record.

Insert option in effect for this table: REPLACE

   Column Name                Position   Len  Term Encl Datatype

--------------------------------------   ---  ---- ---- ---------

   EMPNO                           1:4     4            CHARACTER

   ENAME                          6:15    10            CHARACTER

   JOB                           17:25     9            CHARACTER

   MGR                           27:30     4            CHARACTER

   SAL                           32:39     8            CHARACTER

   COMM                          41:48     8            CHARACTER

   DEPTNO                        50:51     2            CHARACTER

Column EMPNO is NULL if EMPNO = BLANKS

Column MGR is NULL if MGR = BLANKS

Column SAL is NULL if SAL = BLANKS

Column COMM is NULL if COMM = BLANKS

Column DEPTNO is NULL if DEPTNO = BLANKS