MESSAGE LOG and ROW LOG example

This example illustrates the contents and format of the MESSAGE LOG and ROW LOG files.

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

CREATE TABLE customer(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 customer table:

LOAD TABLE customer ...
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:

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

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

2002-02-24 23:04:31 LOAD TABLE customer 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#

2002-02-24 23:05:43 LOAD TABLE customer Completed