wht displays the number of times a query modified ?
Answer Posted / ramakrishna javvaji
SQLERRID(3) field of SQLCA will have no of updates that the
query made.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is dclgen (declaration generator)?
Discuss about db2 bind?
What is the purpose of using commit?
What is nvl in db2?
What are the 2 sqlcodes that are returned?
Mention the downsides of page level lock.
What is the difference between nvl and coalesce?
What is a db2 schema?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is deadlock in db2?
what is db2 restart?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What do you mean by storage group (stogroup)?