Error while inserting Dataset into DB2 using Write method
Posted: Fri Jan 06, 2012 2:35 pm
My Job Structure:
Dataset -> copy stage -> DB2 Enterprise Stage in Write(Append) Mode
Error:
DB2_WRT_ETF_PROGRAM_ASSETS,0: Error Idx = 12;
DB2Driver Embedded SQL message: SQL0804N The application program parameters for the current request are not
valid. Reason code "106". If a host variable or SQLVAR in the SQLDA is
invalid then: host variable/SQLVAR number = "9", SQLTYPE = "484", SQLLEN =
"135135232", host variable/SQLVAR type = "INPUT". SQLSTATE=07002
;
sqlcode = -804;
sqlstate = 07002
SQL0804N and Reason Code 106 : The SQLDATA pointer is invalid or points to insufficient storage.
We have enough space in both DS app server and DB2 .
I see similar issue reported before, but no resolution.
Could you please help me to resolve this issue? [ it is creating problem in production run]
Thanks,
Prasanna
Dataset -> copy stage -> DB2 Enterprise Stage in Write(Append) Mode
Error:
DB2_WRT_ETF_PROGRAM_ASSETS,0: Error Idx = 12;
DB2Driver Embedded SQL message: SQL0804N The application program parameters for the current request are not
valid. Reason code "106". If a host variable or SQLVAR in the SQLDA is
invalid then: host variable/SQLVAR number = "9", SQLTYPE = "484", SQLLEN =
"135135232", host variable/SQLVAR type = "INPUT". SQLSTATE=07002
;
sqlcode = -804;
sqlstate = 07002
SQL0804N and Reason Code 106 : The SQLDATA pointer is invalid or points to insufficient storage.
We have enough space in both DS app server and DB2 .
I see similar issue reported before, but no resolution.
Could you please help me to resolve this issue? [ it is creating problem in production run]
Thanks,
Prasanna