MESSAGE LOG and ROW LOG Example

The following CREATE TABLE statement creates the table that is loaded using a LOAD TABLE statement:

CREATE TABLE Customers(name VARCHAR(80) NOT NULL,
age TINYINT NULL,
sex CHAR(1) NOT NULL,
marital_status CHAR(1) NULL,
birthdate DATE NOT NULL,
credit_card VARCHAR(20)NOT NULL)

The following LOAD TABLE statement loads the data into the Customers table:

LOAD TABLE Customers ...
IGNORE CONSTRAINT UNIQUE 200
MESSAGE LOG 'msg.log' ROW LOG 'row.log'
ONLY LOG UNIQUE, NULL, DATA VALUE
LOG DELIMITED BY '#'

The following raw data is loaded from a disk file using the LOAD TABLE statement above:

Jones John, 19, M, S, 06/19/83, CC
Cleven Bill, 56, M, OSIDJFJ, 02/23/43, CC
Jones John, 339, M, NULL, 01/12/45, NULL
NULL, 55, F, M, 10/02/37, ST

After the LOAD TABLE completes, the MESSAGE LOG file msg.log contains the following information:

2009-05-24 23:04:31 LOAD TABLE Customers: Integrity Constraint Violations
1267 DATA VALUE 4
3216 UNIQUE 1
3216 NULL 6
9677 NULL 1
2009-05-24 23:05:43 LOAD TABLE Customers Completed

After the LOAD TABLE completes, the ROW LOG file row.log contains the following information:

2009-05-24 23:04:31 LOAD TABLE Customers Integrity Constraint Violations
Date Format: yyyy/mm/dd
Time Format: hh:mm:ss
Datetime format: yyyy/mm/dd hh:mm:ss

1137 #Jones John#19#M#S#1983/06/19#CC#
1267 #Cleven Bill#56#M#OSIDJFJ#1943/02/23#CC#
3216 #Jones John#NULL#NULL#S#1945/01/12#NULL#
9677 #NULL#55#F#M#1937/10/02#ST#

2009-05-24 23:05:43 LOAD TABLE Customers Completed