2 new fields are added to oracle table.to populate this I need to execute a sql which willbe using 2 tables and if itsatisfies the criteria of the sqli i need to populate the field with yes. for the 2nd field i have a different sql which i need to execute and then populate that with yes.
can you please let me know how to do this
In the query caluse should i give the names of all the tables involved in the query.
executing sql
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You have not told us which database you are using, but the obvious mechanism seems to be an UPDATE statement containing two nested SELECT statements each of which includes a CASE construct to make the Yes/No decision.
In DataStage, of course, you could perform lookups to make the decision.
But you seen to have the notion of using SQL fixed in your mind for some reason.
In DataStage, of course, you could perform lookups to make the decision.
But you seen to have the notion of using SQL fixed in your mind for some reason.
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.
-
- Participant
- Posts: 88
- Joined: Tue Nov 28, 2006 9:33 pm