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...

how to check the table is empty or not?

Answer Posted / vaneesh khurana

After executing the first query if you find SQLCODE = 100,
then the table is empty.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of base tables?

1085


What is role in db2?

1101


Explain in brief how does db2 determine what lock-size to use?

1034


What is netezza database?

1017


What is meant by union and union all?

1005


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2081


What is the maximum number of columns in a db2 table?

1275


Why db2 is called db2?

1024


What is syscat in db2?

996


What is db2 and what is the use of db2 optimizer?

1049


Explain the benefits you can get from mainframe connect?

968


What is the difference between nvl and coalesce?

1057


Which component is used to execute the sql statements?

1089


What is universal database?

1064


What is a bind in db2?

1036