XML Extender problem : Calling stored procedure : db2xml.dxxShredXML

[Guest_imported]

Hi :

I face a problem when using XML extender XML collection to decompose a XML file using RDB node mapping,

Below is the error I get from the trace file :

dxxrow_to_stmt: SQLExecute failed for INSERT INTO "H001"("H001_BILL_REF","H001_BILL_DATE","H001_BILL_DATE___9","H001_CUST_ACC_NO&quot SELECT * FROM TABLE(VALUES(CAST(? AS varchar(100)),CAST(? AS varchar(10)),CAST(? AS date),CAST(? AS varchar(12)) )) AS T("H001_BILL_REF","H001_BILL_DATE","H001_BILL_DATE___9","H001_CUST_ACC_NO&quot
trace messages: CLI failed for SQLExecute (insert): cliMsg= [IBM][CLI Driver][DB2/NT] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=2, TABLEID=10, COLNO=0" is not allowed. SQLSTATE=23502

cliRC=-1 cliState=23502 sqlcode=-407
dxxrow_to_stmt: Exits, errCode=-57
decompose_element: call dxxrow_to_stmt() returns -57.
decompose_element: Exits, errCode=-57
dxxDecomposeByDAD: call decompose_element() returns -57.
dxxDecomposeByDAD: Exits, errCode=-57
dxxShredXML: call dxxDecomposeByDAD() returns -57.
dxxShredXML: stored procedure exits.


Please help .
Thanks.

Regards,
ghlee