UserDefined SQL

[Xpert]

Hi,

I need to insert oracle sequence values in Oracle OCI stage(Target), what should i have to do? Pls help me. Layout is shown below..


Source ---------> Transformer-----------> Oracle OCI.


I tried with user defined sql. Pls help me.... Thnx in Advance....

[ArndW]

Hello Xpert,

what user-defined SQL did you try and what was the error? Oracle sequences work quite well in DataStage.

[ray.wurlod]

Do NOT provide a key value from the DataStage job Columns collection.

Your SQL should then have the form:

Code: Select all

INSERT INTO tablename(key_col, col2, col3, ...) VALUES (sequencename.NEXTVAL, :1, :2, ...)

Make sure there are as many non key column references in the column names clause and parameter markers in the values list as there are column definitions in the job's Columns collection, and that all data types are compatible.

[Xpert]

Hi,


I got the answer, thnx for ur replies....