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 dynamic cursor?gives syntax for this?
What is lock contention?
Explain about cursor stability?
What is host variable in db2 cobol?
Explain in detail about buffer manager and its functionalities?
What is db2 stogroup?
What is the meaning of -805 SQL return code?
why we create view.
What does reorg do in db2?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
What are column-name qualifiers used?
What is subquery ?