How can you find out the # of rows updated after an update statement?
No Answer is Posted For this Question
Be the First to Post Answer
How to resolve -407 sql code in DB2?
What is null indicator in db2?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
How many databases can be created inside an instance in db2 ?
what is consistency token
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
how can u nderstand the sql stmts executed successfully or not ?
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?
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
What are leaf pages?
What is catalog database in db2?