SEQUENCE.NEXTVAL within OracleOCI stg using WriteMethod=LOAD

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sck
Participant
Posts: 18
Joined: Thu Mar 18, 2004 2:58 pm

SEQUENCE.NEXTVAL within OracleOCI stg using WriteMethod=LOAD

Post by sck »

Hi

Is it possible to use SEQUENCE.NEXTVAL within OracleOCI stage without using WriteMethod=Upsert.

The thinking being that using WriteMethod=Load, I can get better performance. Also WriteMethod=Load does not allow me to define a USER-DEFINED Query

Thanks
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”