LookupStage error - what does this mean?

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
cbres00
Participant
Posts: 34
Joined: Tue Sep 21, 2004 9:20 am

LookupStage error - what does this mean?

Post by cbres00 »

I got this error:
The number of input links must match the number of input datasets.

I have a list of transaction ids I've put in a fileset to use as a reference for several jobs in a sequence. I need to join these transaction ids within Teradata APIs to do some updates and data moves to those rows where I find a match on transid in the fileset.

I have this setup:

LOOKUP stage ------> TD API stage

The sql in the TD API stage is simple:"using (TransId) Update mytable set col1='Y' where transid = :transid "

What am I doing wrong here?

Regards,
cbres00
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The Lookup stage requires a minimum of two input links - the stream input and one or more reference inputs (against which the key-based lookups are performed). On the other end of a reference input there can be a virtual Data Set, a Lookup File Set stage, or a DB2 or Oracle stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply