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
