Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose we have a query for update
update table1
set col1 = 'val1'
where col2=(select .... from ...)
suppose the subquery does not return any record, what will
happen to update?
- 1 Answers
- 6218 Views
- IBM, I also Faced
- E-Mail Answers
Answer / santosh kumar d
If the col2 field having any null value then that value to
be updated.
If col2 doesn't have any null value then record remains same
nothing will be updated.
| Is This Answer Correct ? | 4 Yes | 6 No |
How does one remove entries from the SCT02 table?
Why select is not preferred in embedded sql programs?
The only place of VSAM KSDS in DB2 is?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
What are the 2 sqlcodes that are returned?
What is multi row fetch in db2?
how can we find nth max salary from A table
what is load and unload in db2
What can the SET option of the Repair Utility accomplish?
how 2 resolve the -311 sqlcode
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
COBOL 
