Sqlstate=55039

[dai_lo]

Hi,

when i tried create a table in DB2, it returns me an error code SQLSTATE=55039
how can i avoid getting this error message?
Thanks

[rmiao]

Which version of UDB you are using? Can you list the table space used?

[dai_lo]

DB2 8.1..

I am able to create the following table

CREATE TABLE DB2ADMIN."OSTITEM"(

OSTITEM_ODATE DATE NOT NULL,

OSTITEM_BATCHNO CHAR(3) NOT NULL,

OSTITEM_ITEM CHAR(3) NOT NULL,

OSTITEM_TRANTYPE CHAR(4) NOT NULL,

OSTITEM_ORGAMT DECIMAL(11, 2) NOT NULL,

OSTITEM_APPLY CHAR(1) NOT NULL,

OSTITEM_CURPAYER CHAR(60) NOT NULL,

OSTITEM_DESCRIP CHAR(120) NOT NULL,

OSTITEM_DELIND CHAR(1) NOT NULL,

OSTITEM_POSTMARK DATE,

OSTITEM_SPLIT CHAR(1) NOT NULL WITH DEFAULT ' ',

OSTITEM_SEQ INTEGER NOT NULL WITH DEFAULT ' ',

OSTITEM_REFNO CHAR(12) NOT NULL WITH DEFAULT ' ',

OSTITEM_CARDTYPE CHAR(2) NOT NULL WITH DEFAULT ' ',

OSTITEM_RTN2CASH CHAR(1) NOT NULL,

OSTITEM_CHECKNO CHAR(9) NOT NULL,

PRIMARY KEY (OSTITEM_ODATE, OSTITEM_BATCHNO, OSTITEM_ITEM)

)IN "Alice"

;

But i can create this table

CREATE TABLE DB2ADMIN."OSTVSN"(

OSTVSN_ODATE DATE NOT NULL,

OSTVSN_BATCHNO CHAR(3) NOT NULL,

OSTVSN_ITEM CHAR(3) NOT NULL,

OSTVSN_TIMESTMP TIMESTAMP NOT NULL,

OSTVSN_POLNO CHAR(25) NOT NULL,

OSTVSN_UNDCO CHAR(2) NOT NULL,

OSTVSN_AGENCY CHAR(3) NOT NULL,

OSTVSN_REGION CHAR(3) NOT NULL,

OSTVSN_BRANCH CHAR(3) NOT NULL,

OSTVSN_DEPT CHAR(3) NOT NULL,

OSTVSN_PROFCTR CHAR(4) NOT NULL,

OSTVSN_ENTTYPE CHAR(4) NOT NULL,

OSTVSN_ENTCODE CHAR(10) NOT NULL,

OSTVSN_VSNITEM CHAR(10) NOT NULL,

OSTVSN_GENLEGNO CHAR(10) NOT NULL,

OSTVSN_PAYMTHD CHAR(5) NOT NULL,

OSTVSN_DESCR CHAR(100) NOT NULL,

OSTVSN_AMTSIGN CHAR(1) NOT NULL,

OSTVSN_AMOUNT DECIMAL(11, 2) NOT NULL,

OSTVSN_PROCIND CHAR(1) NOT NULL,

OSTVSN_SPLTDESC CHAR(25) NOT NULL,

PRIMARY KEY (OSTVSN_ODATE, OSTVSN_BATCHNO, OSTVSN_ITEM, OSTVSN_TIMESTMP),

FOREIGN KEY RefOSTI2 (OSTVSN_ODATE, OSTVSN_BATCHNO, OSTVSN_ITEM)

REFERENCES DB2ADMIN."OSTITEM"(OSTITEM_ODATE, OSTITEM_BATCHNO, OSTITEM_ITEM) ON DELETE CASCADE


)

;

[rmiao]

In same table space?