DSXchange

Hi,

We have a DB2 table which contains more than 100 million records. And this table is a part of container logic, where we are performing sparse lookup on this table twice in the same job using ODBC Stage.

This Job runs fine, if we pass less than 100 Records.

If Records are more than 100, Job aborts with the following error Message
[DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]UNACCEPTABLE SQL STATEMENT

Please let me know, How to debug this Error.

Thanks in Advance.

Any reason why you are using an ODBC stage rather than a native DB2 stage?

EDIT - I just spotted in your post that the warning illustrates you are connecting to mainframe DB2.... correct?

Try to change parallel to Sequential mode in lookup stage.