Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



in a table consist of 1000 records among that i was updated 145 record how could i know that ..list..

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

in a table consist of 1000 records among that i was updated 145 record how could i know that ..list..

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

in a table consist of 1000 records among that i was updated 145 record how could i know that ..list..

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

in a table consist of 1000 records among that i was updated 145 record how could i know that ..list..

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

Post New Answer



More DB2 Interview Questions

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  


what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  


I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers  


My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,


When the like statement is used?

0 Answers  






Why do we bind in db2?

0 Answers  


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  


What are catalog tables in db2?

0 Answers  


What is a plan and package in db2?

0 Answers  


The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,


Can you define an Index if the table size less than 10 PAGES?

1 Answers   IBM,


How to define the a field which accepts value till 99999.99 in db2

3 Answers  






Categories