Hi All,
Pls clarify me regarding how to call an oracle sequence inside the data stage?
Sequence in DS
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 45
- Joined: Tue Aug 29, 2006 2:59 am
- Location: Bangalore
Re: Sequence in DS
one way would be to use userdefined sql while you either do the select or insert in the Oracle stage .. i.e. use schema_name.SEQuence_name.nextvalkarthikgk0705 wrote:Hi All,
Pls clarify me regarding how to call an oracle sequence inside the data stage?
an alternate way would be to do the same via a OCI lookup stage.
take a look at viewtopic.php?t=99049
Bibhu
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Just stick it in user-defined SQL.
Code: Select all
INSERT INTO table(keycol,colA,colB) VALUES (seqname.NEXTVAL,:1,:2);
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.