Multiple Update issue
Moderators: chulett, rschirm, roy
Multiple Update issue
Hi,
I am trying to update a ORACLE table using oracle connector in DS 8.7 through before and after job SQL.
It worked for me once but if i change the value for doing Unit testing its not giving proper results.
Please advise what needs to be done in such case.
I am trying to update a ORACLE table using oracle connector in DS 8.7 through before and after job SQL.
It worked for me once but if i change the value for doing Unit testing its not giving proper results.
Please advise what needs to be done in such case.
Thanks,
Akarsh Kapoor
Akarsh Kapoor
Re: Multiple Update issue
What you tried? share the code.
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Re: Multiple Update issue
In Before SQL just giving as
UPDATE
Table name
SET
Clm = 'A'
WHERE Clm In (' ','B','C','E','9') ;
Same query is working in DB but not updating through DS.
UPDATE
Table name
SET
Clm = 'A'
WHERE Clm In (' ','B','C','E','9') ;
Same query is working in DB but not updating through DS.
Thanks,
Akarsh Kapoor
Akarsh Kapoor
Re: Multiple Update issue
UPDATE
Table name
SET
Clm = 'A'
WHERE Clm In (' ','B','C','E','9') ;
What are you actually using as the "Table name" value?
Table name
SET
Clm = 'A'
WHERE Clm In (' ','B','C','E','9') ;
What are you actually using as the "Table name" value?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: Multiple Update issue
It's actual oracle DB table name which i need to update.
Thanks,
Akarsh Kapoor
Akarsh Kapoor
in that case, did you include the schema name?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
What is your error message?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Actually what happend i was using sqldeveloper to access Oracle DB.
When i was updating records for unit testing i was doing commit but it was not working then i used commit option given in sqldeveloper which worked.
After that when i ran before and after SQL it worked perfect for me.
So basically it was commit statement which was not working and causing to not update DB for unit testing. It was not related to DS.
When i was updating records for unit testing i was doing commit but it was not working then i used commit option given in sqldeveloper which worked.
After that when i ran before and after SQL it worked perfect for me.
So basically it was commit statement which was not working and causing to not update DB for unit testing. It was not related to DS.
Thanks,
Akarsh Kapoor
Akarsh Kapoor