Oracle OCI9 stage and Update/Insert w/ Sequences

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
kh
Participant
Posts: 21
Joined: Mon Jun 09, 2003 11:16 am

Oracle OCI9 stage and Update/Insert w/ Sequences

Post by kh »

I would like to use the OCI9 stage with either the Update/Insert or Insert/Update action, but the insert statement will require the use of a sequence, which I typically handle via user-defined SQL.

Is there a way to do this? I can't seem to figure it out. Thanks!
Kevin Hart
Apollo Group
ogmios
Participant
Posts: 659
Joined: Tue Mar 11, 2003 3:40 pm

Re: Oracle OCI9 stage and Update/Insert w/ Sequences

Post by ogmios »

Has been handled pretty recently at:

viewtopic.php?t=86538

Ogmios
Post Reply