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
- 6243 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to check table size in db2 sap?
What are the bind parameters ibm db2?
What is the result of open cursor statement?
What is catalog database in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is with ur in db2?
Can we insert update delete in view?
What are catalog tables in db2?
What is package in cobol db2?
What is nvl in db2?
What do you mean by cursor?
What is the meaning concurrency in the db2 database?
How to find the number of rows in db2 tables?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
