Hi
I m using Teradata API for updating a teradata table values from a sequential file but not able to figure out how to specify both incoming file and updatable table in the API stage as it allows me to specify only 1 of them in the input tabs.
Thanks
Amit
Updates using Teradata API
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That is true of almost all passive stages in parallel jobs. You need to adopt a different mind set from your server job design skills. Parallel jobs do not accept this "blocking" strategy (so that fastest possible throughput can be obtained, without causing dataflow deadlocks and permitting of re-partitioning, etc.) - the only way to achieve it is to use two jobs in sequence.
In your particular job you may be able to use two Teradata API stages; one accepting data and one writing data.
In your particular job you may be able to use two Teradata API stages; one accepting data and one writing data.
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.