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
LookupStage error - what does this mean?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.