DSXchange

Hi, Changed the query as follows and its working: if Substrings(cms_p11d.ORDERNO,1,1) = 'R' then 'Reallocation Order' else if Substrings(cms_p11d.ORDERNO,1,1) = 'S' then 'STH Car Order' else if Substrings(cms_p11d.ORDERNO,1,1) = '0' then 'New Car Order' else if Substrings(cms_p11d.ORDERNO,1,1) = '1'...

Hi , The datastage job in figure shows compile time error at the transformer stage. http://img444.imageshack.us/my.php?image=dsjobvc4.jpg As in figure I have an input column cms_p11d.orderno which I map to two columns in the output table. One mapping of the input column is used with an if statement....

Yes ..thats right..i am facing the same issue with all the threads.

I tried clicking the "Mark Topic : Resolved" button many times.
Still the status is currently open .
Is there anything else that needs to be done?

Athira

Done.. its working...thankyou.

Hi,

Within the Datastage Director from the main menu Job -> Cleanup Resources option is not active for any of the jobs. Please do let me know the scenarios when the same would be active.

Athira

Its working.....
The destination table already had some data that was inserted w/o using sequence (for the primary key column) and when i tried to insert data using sequence it created all the mess.
once again all the inputs were really very valuable for a beginner.

Thanks a lot
Athira

Thankyou for the valuable inputs. I am checking with the sequence.

Athira

The primary key of the table is vom_order_no and the primary key contraint is named ODB.VOM_ORDER_NO_PK1, a sequence is used to populate it as in query below INSERT INTO ODB.VAS_ORDER_MASTER_NEW (VOM_ORDER_NO,VOM_CUSTOMER_EIN,VOM_SUBMITTED_DT,VOM_START_DT,VOM_ACTUAL_END_DT,VOM_ORDER_TYPE,VOM_MONTHLY...

Hi, I am using a sequence in a user defined sql query to insert data into an Oracle table using ORA OCI stage. But only a very few data is getting inserted saying "unique key constraint has violated", are there any issues using the sequence in a user defined sql in an ORA OCI ? The job des...

I have tried that out many a times

Yes, I believe the topic can be marked as resolved.

Thanks
Athira

sorry i didnt get that statement , i tried it out now ... anyways the ORA-01036 is no longer popping up.. it gave me a new warning and a fatal error :) The warning : ORA1..Oracle_OCI_3: INSERT INTO ODB.VAS_ORDER_MASTER_NEW (VOM_ORDER_NO,VOM_CUSTOMER_EIN,VOM_SUBMITTED_DT,VOM_START_DT,VOM_ACTUAL_END_D...

I already do have the sequence created in the Oracle database. An insert statement into the oracle database should include the sequence which is mandatory I believe, please correct me if wrong. So when defining the insert query in the stage how will the query be ( with the sequence also specified) ?

How can then the sequence be used?

When using ODBC stages I did create user-defined query where sequences where used and it did work fine, in that case i didn't mention the column in the ODBC stage.