DB2 and talend
I do get the error below when i try to load table in DB2 iseries through ETL tool Talend
[IBM][iSeries Access ODBC Driver]Column 6: CWB0111 - A buffer passed to a system call is too
small to hold return data
can anyone guide me what could be the error
Software/Hardware used:
Software/Hardware used:
ASKED:
July 15, 2008 11:30 AM
UPDATED:
July 16, 2008 3:57 PM
Answer Wiki:
Hello,
This error is a result of how the iSeries ODBC driver handles return strings. It requires 1 additional byte beyond the defined string length.
Possible workarounds:
1) Use the previous version IBM Client Access ODBC driver instead of the IBM iSeries Access ODBC driver.
2) Temporarily change all char and varchar stored procedure parameters. Increase their size each by 1 byte then re-apply the RSSql data object. Then change the stored procedure parameters back to their original size.
3) Use another database to proxy the data between RSSql and DB2 (like MSSQL Server distributed database transaction).
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
