wht displays the number of times a query modified ?
Answers were Sorted based on User's Feedback
Answer / ramakrishna javvaji
SQLERRID(3) field of SQLCA will have no of updates that the
query made.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / mehdee
- If you mean what displays the number of time that a DB2
row has been modified, then my answer is when you create
this DB2 table add a column like SEQ_NUM and as you define
it like SMALLINT, right there you can have it increamented
by 1. Please look into manual for it's exact format.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the difference between cursor and select statement?
What is db2 command?
What is runstats utility in db2?
What is meant by AUTO COMMIT?
Mention the various locks that are available in db2.
When can an insert of a new primary key value threaten referential integrity?
What is a Cartesian product?
What is buffer pool in the db2 database?
What is copy book?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
What are concurrency issues?
Can one database have multiple instances?