Also, is there a way to control the layout of the table? Or at least to make it multiset vs. set? What happens if I capture the DDL for the table and recreate it manually as MULTISET? Will DataStage still acknowledge it?
Here is the DDL that gets generated:
Code: Select all
CREATE SET TABLE acapsd_daily.terasync ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
cookie INTEGER NOT NULL,
optype BYTEINT NOT NULL,
ctlstate BYTEINT NOT NULL,
eventcount INTEGER NOT NULL,
lsn INTEGER,
blockcount INTEGER,
query VARCHAR(1024) CHARACTER SET LATIN NOT CASESPECIFIC,
username VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
dbname VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
recordcount FLOAT,
bytecount FLOAT,
rejectcount FLOAT,
starttime INTEGER,
endtime INTEGER)
UNIQUE PRIMARY INDEX ( cookie );
Brad.