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
- 6332 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 buffer pool?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
What is the significance of DB2 free space and what parameters control it?
where will u check for sqlcode ?
how to unload different table data into different gdg files/ vsam files.
pls explain the precompilation process of cobol-db2 pgm
How will you delete duplicate records from a table?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
What is Skeleton cursor table (SKCT)?
On the create tablespace, what does the CLOSE parameter do?
COBOL 
