ORAOCI9 and sequences
Posted: Tue Sep 09, 2003 5:20 pm
We intend to use DataStage for integrating data between OLTP applications. Many of the target tables are in Oracle and have primary keys that are typically populated (by the OLTP application) using a sequence (sequence_name.nextval).
Is there a way to get the ORAOCI9 stage to do this with a user-defined SQL statement? (Example: INSERT INTO table (id, fld1, fld2) VALUES (myseq.nextval, :1, :2)
It seems like this should be fairly simple to do, but as soon as you're forced to enter the table name on the General tab, your user-defined query is lost (replaced with a generated one).
Is there a way to do this? How about a work-around?
Regards, Kevin
Is there a way to get the ORAOCI9 stage to do this with a user-defined SQL statement? (Example: INSERT INTO table (id, fld1, fld2) VALUES (myseq.nextval, :1, :2)
It seems like this should be fairly simple to do, but as soon as you're forced to enter the table name on the General tab, your user-defined query is lost (replaced with a generated one).
Is there a way to do this? How about a work-around?
Regards, Kevin