Sequence in DS

[karthikgk0705]

Hi All,

Pls clarify me regarding how to call an oracle sequence inside the data stage?

[bibhudc]

Hi All,

Pls clarify me regarding how to call an oracle sequence inside the data stage?

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.nextval

an alternate way would be to do the same via a OCI lookup stage.

take a look at viewtopic.php?t=99049

[keshav0307]

You can write a routine to call this oracle sequence, and call the routine in your job

[ray.wurlod]

Just stick it in user-defined SQL.

Code: Select all

INSERT INTO table(keycol,colA,colB) VALUES (seqname.NEXTVAL,:1,:2);