I want to check if there is a method where you read a value from Oracle Table and pass that value on Sequencer
I know i can do this by having a job which reads from oracle table writes to a file and then read that file using read file stage and then use that value in sequencer......
To give my scenario... I have to generate a batch id which increment on each run ........I am planning to use a table which just holds a value and increments after each run ....I want to know if we I can directly read from the table and pass on the batch id variable in all my datastage jobs
Thanks
Accesing Variables in Sequences
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
My preferred technique is to have a server job read the value and store the value in the job's user status area. This can be accessed as the Job activity's $UserStatus activity variable.
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.