CREATE TABLE TABLE1(C1 INT NOT NULL,C2 CHAR(8),C3 INT) IN PDBUSER01
source fes1:/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),(PDBUSER05))
CREATE INDEX INDEX2 ON TABLE1(C2,C1) IN ((PDBUSER04),(PDBUSER06))
source fes1:/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),(PDBUSER05))
CREATE INDEX INDEX2 ON TABLE1(C2,C1) IN ((PDBUSER04),(PDBUSER06))
source PDBUSER01 bes1:/usr/load_file1 error=/usr/err1 1 |
source PDBUSER02 bes2:/usr/load_file2 error=/usr/err2 1 |
CREATE TABLE TABLE2(C1 INT,C2 BLOB
IN ((LOBUSER01),(LOBUSER02)))
IN ((PDBUSER01) C1 > 10,(PDBUSER02))
CREATE INDEX INDEX2 ON TABLE2(C1)
IN((PDBUSER03),(PDBUSER04))
source PDBUSER01 bes1:/usr/load_file1 error=/usr/err1 1 |
CREATE TABLE TABLE2(C1 INT,C2 BLOB
IN ((LOBUSER01),(LOBUSER02)))
IN ((PDBUSER01) C1 > 10,(PDBUSER02))
CREATE INDEX INDEX2 ON TABLE2(C1) IN((PDBUSER03),(PDBUSER04))
source fes1:/usr/load_file1 1 |
CREATE TABLE SCORE_TABLE
(NUMBER CHAR(6) UNIQUE CLUSTER KEY IN
((PDUSER03),(PDUSER04))
NAME NCHAR(10),
SUBJECT_NAME NCHAR(8) ARRAY[5],
SCORE INT ARRAY[5])
IN ((PDUSER01) < = 1Z9999,(PDUSER02))
source fes1:/usr/arrload_file1 1 |
CREATE TABLE TBL01(C1 INTEGER,C2 VARCHAR(10),C3 SGMLTEXT ALLOCATE
(SGMLTEXT IN LOBUSER01) PLUGIN ...)
IN PDBUSER01
CREATE INDEX INDEX1 USING TYPE NGRAM ON TBL01(C3) IN PDBUSER02
1,"HiRDB",/usr/lob/file01 |
C1 1 |
source fes1:/usr/load_file1 1 |
CREATE TABLE TBL02(C1 INTEGER,C2 DECIMAL(7,0),C3 GEOMETRY)
IN PDBUSER02
C1,type=integer 1 |
source fes1:/usr/load_file2 1 |
CREATE TABLE TBL03(C1 INTEGER,C2 BLOB(4096) IN LOBUSER01),
C3 SGMLTEXT ALLOCATE
(SGMLTEXT IN LOBUSER02) PLUGIN ...)
IN PDBUSER03
CREATE INDEX INDEX1 USING TYPE NGRAM ON TBL03(C3) IN PDBUSER04
source fes1:/usr/load_file3 1 |
CREATE TABLE TBL04(C1 INTEGER,C2 BLOB(100) IN
(LOB11),(LOB12)),
C3 SGMLTEXT ALLOCATE
(SGMLTEXT IN ((LOB21),(LOB22))
PLUGIN...)
IN ((PDBUSER01) C1 >
1000,(PDBUSER02))
CREATE INDEX INDEX1 USING TYPE NGRAM ON TBL04(C3) IN ((PDBUSER03),(PDBUSER04))
source fes1:/usr/load_file1 err=/usr/err 1 |
lobdata /usr/lob1 1 |
lobdata /usr/lob2 1 |
This example loads data in data loading wait status from audit trail files located in unit 2 (un02) into the audit trail table (SQL_AUDIT_TRAIL) defined on the back-end server (bes1) at unit 1 (un01). |
source fes2:(uoc) 1 |