DSXchange

Can i do an update/delete on a different table than what is being used in the SELECT of the oracle enterprise stage? They both are in the same schema

My scenario is to first run an update on <table1> before i start reading another table <table2>. Can i do both in one Oracle Enterprise stage.. ?

I have used Open command option on the stage where i specified the update statement. The job when run doesnt throw any errors, but it doesnt execute the update either..

It is possible. May the update condition is not met. Try something like a truncate on a temp table that has a few rows to verify that it actually works.

I actually have no condition for the update.. i just have a plain 'update <tablename> set <column_name> = sysdate

When i enclose the update in single quotes, i get the sql -900 error (Invalid SQL statement), but when i remove the single quotes around it and just use the simple update statement , i get no errors, but i get no result either !!

Did you actually code a reject link in your output stage to see if some error is being found on the execution of the statement?

Normally I wouldn't see a problem with user-defined SQL going to a different table in the same instance.

No ArndW, i have no reject link. This is a source stage reading data from an oracle table, so i havent coded a reject link. There is just no entry in the director log for me to know whether this (BEFORE) OPen command did anything or not.. i mess with the syntax, it throws me an error though !!

Do things change if you add a semicolon? Also, this will get executed on each processing node (in this case it wouldn't make much of a difference, but it is important to realize what DS does).