Sparse Lookup with DB2 ODBC Stage.

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
subasht
Participant
Posts: 8
Joined: Mon Sep 19, 2005 7:45 pm

Sparse Lookup with DB2 ODBC Stage.

Post by subasht »

Does any body used OBDC stage to do sparse lookup against DB2? I am receiving the SQL error "SQL0805N" with package "NULLID.SYSLH203" not found. The lookup works fine in test with less number of rows.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Welcome aboard! :D

Sparse lookup is documented only to work with DB2 and Oracle stage types (at least in version 7.1).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Eric
Participant
Posts: 254
Joined: Mon Sep 29, 2003 4:35 am

Post by Eric »

Are you using a DB2 8.x client running against a DB2 7.x Server?
Top
subasht
Participant
Posts: 8
Joined: Mon Sep 19, 2005 7:45 pm

Post by subasht »

No. It is both 8.x.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”