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 |
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
What is a NULL value? What are the pros and cons of using NULLS?
How does DB2 determine what lock-size to use?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
What is reorg in DB2
What is view db2?
What is collection in db2 bind?
What is the syntax required for the creation of a cursor?
What is lock escalation?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation