Interested to Buy Any Domain ? << Click Here >> for more details...
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....
- 4 Answers
- 11395 Views
- Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / girihs kumar
SQLERRD Contains the number of rows affected by a DB2
INSERT/DELETE operation. if the operation is DELETE, this
contains number of rows deleted after the execution of the
query.
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / diana
SQLERRD Contains the number of rows affected by a DB2
INSERT/DELETE operation.
I support this answer
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / vaneeshkhurana
In case of any requirement where you have to display the
recently updated records, DB2 generally contains an
additional time stamp coulomb which can be updated with
current time stamp in the updated query.
Now when you want to display the recently updated records,
and an additional AND conditional can be added stating where
time stamp > time when update query ran.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / girish kumar
i don't know exactly but what i feel, DB2 active logs
records events of all data changes in DB2. In case of
failure, it uses this data to recover the lost information.
CORRECT ME IF IAM MISTAKE.
| Is This Answer Correct ? | 0 Yes | 1 No |
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What are the two types of logging in the db2 database? Explain them.
What is alias in db2?
What is a bind card?
What is explain plan in db2?
What is a data page?
Which isolation level provides maximum concurrency?
What is the picture clause of the null indicator variable?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
How many Buffer pools are there in DB2 and what are they?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
COBOL 
