Sure, here it is: // EXEC PGM=ARIDBS,SIZE=AUTO,PARM='DBNAME(SAMPLE)' CONNECT DB2INST1 IDENTIFIED BY xxxxx; SET AUTOCOMMIT ON; COMMENT '************** CONTROL CENTER TABLE REORG ************' COMMENT '* DATABASE: STLDB01 *' COMMENT '* TABLE: "STL01"."ERS_HISTORY" *' COMMENT '* DATE: 03-24-04 09:00:00 *' COMMENT '********************************************************' DROP TABLE "STL01"."THD002" ; COMMIT WORK; SET ERRORMODE (CONTINUE); SET AUTOCOMMIT (ON); COMMENT '***** CREATE TABLE *****' CREATE TABLE "STL01"."THD002" ( "EHI_RECORD_CODE" CHAR(2) NOT NULL ,"EHI_ORG" CHAR(1) NOT NULL ,"EHI_SSN" CHAR(9) NOT NULL ,"EHI_DATE" DATE NOT NULL ,"EHI_DEPT" CHAR(3) NOT NULL ,"EHI_BI_WKLY_RATE" DECIMAL(7,2) NOT NULL ,"EHI_BI_PCT_EMPLYD" DECIMAL(5,4) NOT NULL ,"EHI_BI_PREFIX" CHAR(1) NOT NULL ,"EHI_BI_CLASS_CODE" CHAR(4) NOT NULL ,"EHI_BI_GRADE" CHAR(2) NOT NULL ,"EHI_BI_SHIFT" CHAR(1) NOT NULL ,"EHI_BI_STEP_1" CHAR(1) NOT NULL ,"EHI_BI_STEP_2" CHAR(1) NOT NULL ,"EHI_REASON_CODE" CHAR(2) NOT NULL ,"EHI_SICK_LV_BAL" DECIMAL(7,2) NOT NULL ,"EHI_SICK_CLASS" CHAR(10) NOT NULL ,"EHI_SICK_CODE" CHAR(2) NOT NULL ,"EHI_ANNL_ERS_WGS" DECIMAL(9,2) NOT NULL ,"EHI_ANNL_SERVICE" SMALLINT NOT NULL ,"EHI_CONTR_TOTAL" DECIMAL(7,2) NOT NULL ,"EHI_CONTR_WITHINT" DECIMAL(7,2) NOT NULL ,PRIMARY KEY (EHI_ORG, EHI_SSN, EHI_RECORD_CODE, EHI_DATE ,EHI_REASON_CODE) ) ; CREATE INDEX THD002_REC_CODE_I ON STL01.THD002 (EHI_RECORD_CODE); CREATE INDEX THD002_ORG_SSN_I ON STL01.THD002 (EHI_ORG, EHI_SSN); CREATE INDEX THD002_SSN_I ON STL01.THD002 (EHI_SSN); CREATE INDEX THD002_ORG_I ON STL01.THD002 (EHI_ORG); CREATE INDEX THD002ORGSSNRECI ON STL01.THD002 (EHI_ORG, EHI_SSN, EHI_RECORD_CODE ,EHI_REASON_CODE); SET ERRORMODE (CONTINUE); SET AUTOCOMMIT (ON); COMMIT WORK;
Works just fine. Other tests included only loading a few columns (same result, usually complained about a different variable), reducing the number of table elements down by 5 until the final test which only had a single element in the table (still complained). My working assumption now is that I had DB2 V8.2 64 bit running. I'm generating a new Linux image of SLES9 31 bit and install the 31 bit flavor of DB2 V8.2. Other shops have this running and it seems to work. There is something different here. Eventually I will find it. Tom Duerbusch THD Consulting >>> [EMAIL PROTECTED] 7/6/2006 2:51 PM >>> Is it possible to have a look at the "create table statement" ? greets
