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
What is nvl in db2?
Are views updateable?
Explain correlated sub-queries.
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How is deadlock resolved?
Explain various types of locks in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is null in db2?
What is the maximum size of varchar data type in db2?
Mention data types used in db2 ?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How can the duplicate values be eliminated from db2 select?
What is the purpose of using commit?
What is the difference between bind and rebind in db2?
What is database manager in db2?