wht displays the number of times a query modified ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1859


What is iseries database?

790


What is an instance in db2?

776


Is ibm db2 free?

771


What is the difference between plan and package in db2?

844


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

849


What is drop table?

782


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

823


Which command is used to remove all rows from a table?

789


What is buffer pool?

853


what is the responsibility of the construction superintendent

1890


What does runstats do in db2?

778


What is the max length of sqlca?

970


Describe major components of db2?

860


Explain packages.

875