Index Space in table creation of DB2 Stage

[bmarko22]

I would like to allow a DB2 UDB API stage to create out target table but I don't see any way to tell the stage that I need the indexes created in an index space separate from the table. I did notice there is a User-defined DDL option and I was able to add an INDEX IN line successfully. It still created the primary keys index in the general system default space. Perhaps there is a way to move around the sql to have the PK index created in the index space?

Here is my User defined DDL: (it's almost like bec the PK is created before the INDEX IN that it missed it)

CREATE TABLE UTLDM.MISSING_LABOR_AG_T (
SITE_LOC_ID CHAR(8) NOT NULL,
CTRY_CD CHAR(3) NOT NULL,
CMPNY_CD CHAR(8) NOT NULL,
WK_ENDING_DT DATE NOT NULL,
EMP_SER_NUM CHAR(6) NOT NULL,
GRP_ID CHAR(8) NOT NULL,
DIV_CD CHAR(2) NOT NULL,
, PRIMARY KEY (SITE_LOC_ID, CTRY_CD, CMPNY_CD, WK_ENDING_DT, EMP_SER_NUM) )
IN UTILTS
INDEX IN UTILTS_IDX

[ray.wurlod]

Don't really know. Have your DB2 DBA trace the DML statement that is actually being received from the client (DataStage, that is).