Hi,
I am trying to call Sequence from Database to generate a key in the datastage. Please advice me how to call a sequence in datastage. I am not refering to JOBSequence.
Thanks in advance.
Calling Sequence from DataStage
Moderators: chulett, rschirm, roy
Follow Kim's advice, but the general idea is that you will use a reference lookup to the OCI stage and custom SQL that does the select of the next value from the sequence.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle