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....
UserDefined SQL
Moderators: chulett, rschirm, roy
UserDefined SQL
With regards,
Xpert
Xpert
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do NOT provide a key value from the DataStage job Columns collection.
Your SQL should then have the form:
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.
Your SQL should then have the form:
Code: Select all
INSERT INTO tablename(key_col, col2, col3, ...) VALUES (sequencename.NEXTVAL, :1, :2, ...)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.