HI ALL

When i am running ETL(Extraction Transform Load) on DB2 OLAP

some of the tasks are failing with the following error Code:

WRT_8036 Target: W_LST_OF_VAL_G (Instance Name: [W_LST_OF_VAL_G])
WRT_8038 Inserted rows - Requested: 10140 Applied: 10140
Rejected: 0 Affected: 10140

WRITER_1_*_1> Tue Dec 19 04:23:15 2006
WRITER_1_*_1> WRT_8229 Database errors occurred:
[IBM][CLI Driver][DB2/AIX64] SQL0302N The value of a host variable in
the EXECUTE or OPEN statement is too large for its corresponding use.
SQLSTATE=22001 sqlstate = 22001

Database driver error...
Function Name : Execute
SQL Stmt : INSERT INTO
W_LST_OF_VAL_G(DATASOURCE_NUM_ID,ETL_PROC_WID,INTEGRATION_ID,NAME,ROW_WID,TYPE,VAL,HIGH,LOW,ORDER_BY)
VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[IBM][CLI Driver][DB2/AIX64] *SQL0302N The value of a host variable in
the EXECUTE or OPEN statement is too large for its corresponding use.
SQLSTATE=22001 sqlstate = 22001*

Database driver error...



Can anyone please help me on this

Thanks
Prachi

DB2 & UDB email list listserv db2-l LazyDBA home page