Interested to Buy Any Domain ? << Click Here >> for more details...
wht displays the number of times a query modified ?
- 2 Answers
- 6997 Views
- TCS, I also Faced
- E-Mail Answers
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 Cartesian product?
What is the difference between db2 and oracle?
What is dbrm? When it will be created?
What is deadlock in db2?
What is EXPLAIN?
What techniques are used to retrieve data from more than one table in a single SQL statement?
What is pagespace?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What is buffer pool and list some of them?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
Which component is responsible for db2 startup and shutdown?
The only place of VSAM KSDS in DB2 is?
COBOL 
