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
- 6149 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 a collection in db2?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
define clustering index.
Define sqlca.
How can you quickly find out the # of rows updated after an update statement?
What will the FREE command do to a plan?
what is load and unload in db2
what is the use of cursors?
What is a host variable?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
COBOL 
