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 |
This example loads data into table TABLE2. The explanation is based on the input data file in a data format unique to the fixed-size data format.
CREATE TABLE TABLE2(C1 DECIMAL(7,2), |
303030303130304142434445464748494a00000001 |
pdload -a -c column_inf TABLE2 control_file |
C1,type=adec(7,2) 1 |
option allspace=zero 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 |
This example loads data into table TABLE1 using the specification unit acquisition method, and adds sequence numbers as column data in column C2. The example assumes that the following table and sequence generator have been defined:
CREATE TABLE USER01.TABLE1(C1 INT,C2 INT,C3 VARCHAR(10)) IN PDBUSER01
AS INTEGER START WITH 1 INCREMENT BY 1 MAXVALUE 9999 CYCLE IN PDBUSER01 |
C1 1 |
source /usr/load_file1 1 |