wht displays the number of times a query modified ?
- 2 Answers
- 6550 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 meant by AUTO COMMIT?
How to find last record before record through SQLRPGLE?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
What is deadlock?
What is REORG? When is it used?
What do you mean by rollback?
how can i pull up a query which was previously stored in qmf
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
What is clone table?
What are the prerogatives?
How is a typical DB2 batch program executed ?
COBOL 
