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....
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 |
What are some characteristics of columns that benefit from indexes?
What is buffer pool?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
What is the syntax for creating a table in the db2 database?
How do we specify index to include or not during bind process.
What is query_cache_limit?
What is sqlcode -922 ?
what is the input to PLAN? what is the input to DBRM?
Compare a subselect to a join?
What is lock contention?
What are leaf pages?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,