DB2 and talend

160 pts.
Tags:
AS/400 errors
DB2
DB2 Universal Database
iSeries
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
ASKED: July 15, 2008  11:30 AM
UPDATED: July 16, 2008  3:57 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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).

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following