Reference lookup works in ODBC but not Oracle

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Welcome aboard.

Your lookup is retrieving more than one row, but the OCI stage does not support returning more than one row from a reference lookup. The only stage types that do are ODBC and UniVerse. Of these, only ODBC can be used to connect to Oracle tables. But for that to work you still must select the "allow multiple rows returned" check box.
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
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”