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 a collection?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
How do I import data from excel to db2?
What os does db2 run on?
What is Call attach facility? How does it work?
when does the SQL statement gets executed when you use cursor in the application programming ?
Where besides the DB2 catalog is database object information stored by DB2?
What is the difference between dbm cfg and db cfg file in db2 ?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
What is the picture clause of null indicator variable?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?