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 a collection?

2 Answers  


Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 Answers  


If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,


How do I import data from excel to db2?

0 Answers  


What os does db2 run on?

0 Answers  


What is Call attach facility? How does it work?

1 Answers   Syntel,


when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,


Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  


What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,


What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,


What is the picture clause of null indicator variable?

0 Answers  


Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

1 Answers  


Categories