Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


wht displays the number of times a query modified ?

Answers were Sorted based on User's Feedback



wht displays the number of times a query modified ?..

Answer / ramakrishna javvaji

SQLERRID(3) field of SQLCA will have no of updates that the
query made.

Is This Answer Correct ?    6 Yes 2 No

wht displays the number of times a query modified ?..

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

More DB2 Interview Questions

What is the difference between cursor and select statement?

0 Answers  


What is db2 command?

0 Answers  


What is runstats utility in db2?

0 Answers  


What is meant by AUTO COMMIT?

3 Answers  


Mention the various locks that are available in db2.

0 Answers  


When can an insert of a new primary key value threaten referential integrity?

2 Answers   Mind Tree,


What is a Cartesian product?

2 Answers  


What is buffer pool in the db2 database?

0 Answers  


What is copy book?

1 Answers   Thomson Reuters,


In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,


What are concurrency issues?

0 Answers  


Can one database have multiple instances?

0 Answers  


Categories