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 |
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
What is node in db2?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
How to create backup table in db2?
What does DML stand for and what are some examples of it?
What is the reason behind not using select * in embedded sql programs?
How to view db2 table structure?
How can you do the explain of a dynamic sql statement?
What is a system catalog table in db2?
What do you mean by cursor?