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..
Open Command in Oracle Enterprise stage
Moderators: chulett, rschirm, roy
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 !!
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.
Normally I wouldn't see a problem with user-defined SQL going to a different table in the same instance.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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).
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>