Sparse lookup Fails.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ssunkad
Participant
Posts: 2
Joined: Wed Jul 18, 2007 4:20 am
Location: Mumbai
Contact:

Sparse lookup Fails.

Post by ssunkad »

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.
gfgdfgd
miwinter
Participant
Posts: 396
Joined: Thu Jun 22, 2006 7:00 am
Location: England, UK

Post by miwinter »

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?
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
uppalapati2003
Participant
Posts: 70
Joined: Thu Nov 09, 2006 2:14 am

Re: Sparse lookup Fails.

Post by uppalapati2003 »

Try to change parallel to Sequential mode in lookup stage.
Srini
Post Reply