CREATE TABLE TABLE1(C1 INT,C2 CHAR(8),C3 INT) IN PDBUSER01
CREATE INDEX INDEX1 ON TABLE1(C1) IN PDBUSER03
1,ABCDEFG,99999, |
C1 1 |
source /usr/load_file1 error=/usr/err1 1 |
1 ABCDEFG 99999 |
Note: there is a linefeed code at the end of the line.
C1,type=char(3) 1 |
source /usr/load_file1 error=/usr/err1 1 |
CREATE TABLE TABLE1(C1 INT NOT NULL,C2 CHAR(8),C3 INT)
IN ((PDBUSER01) C1 > 10,(PDBUSER02))
CREATE INDEX INDEX1 ON TABLE1(C1) IN ((PDBUSER03),(PDBUSER04))
CREATE INDEX INDEX2 ON TABLE1(C2,C1) IN (PDBUSER05)
source /usr/load_file1 error=/usr/err1 errdata=/usr/err_data,1000 1 |
CREATE TABLE TABLE1(C1 INT NOT NULL,C2 CHAR(8),C3 INT)
IN ((PDBUSER01) C1 > 10,(PDBUSER02))
CREATE INDEX INDEX1 ON TABLE1(C1) IN ((PDBUSER03),(PDBUSER04))
CREATE INDEX INDEX2 ON TABLE1(C2,C1) IN (PDBUSER05)
source PDBUSER01 /usr/load_file1 error=/usr/err1 1 |
source PDBUSER02 /usr/load_file2 error=/usr/err2 1 |
You cannot use INDEX2 as is.
Execute batch index creation with pdrorg (specifying -k ixmk) using index information files 3 and 4 to which index information has been output.
CREATE TABLE TABLE1(C1 INT NOT NULL,C2 CHAR(8),C3 INT)
IN ((PDBUSER01) C1 > 10,(PDBUSER02))
CREATE INDEX INDEX1 ON TABLE1(C1) IN ((PDBUSER03),(PDBUSER04))
source host1:/usr/load_file1 error=/usr/err1 1 |
CREATE TABLE TABLE2(C1 INT,C2 BLOB IN LOBUSER01) IN PDBUSER01
CREATE INDEX INDEX2 ON TABLE2(C1) IN PDBUSER02
source /usr/load_file1 error=/usr/err1 1 |
CREATE TABLE TABLE2(C1 INT,C2 BLOB IN LOBUSER01) IN PDBUSER01
CREATE INDEX INDEX2 ON TABLE2(C1) IN PDBUSER02
source /usr/load_file1 error=/usr/err1 1 |
CREATE TABLE TABLE2(C1 INT,C2 BLOB IN LOBUSER01) IN PDBUSER01
CREATE INDEX INDEX2 ON TABLE2(C1) IN PDBUSER02
lobdata /usr/lob 1 |
This example loads data from audit trail files waiting for data loading into the audit trail table SQL_AUDIT_TRAIL. The example assumes that no index has been defined for the audit trail table. |
source (uoc) 1 |