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
- 6269 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 |
What is the difference between primary key & unique index ?
Give the name of some fields form sqlca.
What are the isolation levels possible ?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the difference between Primary key and unique index?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What is a page?
How would you find out the total number of rows in a db2 table?
What are the disadvantages of PAGE level lock?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is REORG? When is it used?
What are leaf pages?
COBOL 
