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


EXEC-SQL
SELECT 1
INTO :X
FROM TAB1
END-EXEC
X is defined as s9(4) comp value zeroes
So, if there is a row in the table (i.e. the table is not
empty), 1 gets moved to variable X.
Did not have resources to run the query and validate ,



Please let me know if I am wrong

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of commit in db2?

1073


What is precompiler in db2?

1010


i want to maintain uniqueness on pdf without make lf??????????

2153


What is the use of db2?

1051


What is buffer pool and list some of them?

1025


Explain about open switch business continuity software?

1125


How and when does the db2 enforces the unique key?

1080


What are bind parameters in db2?

1044


What is bind package and plan in db2?

1053


What is difference between isnull and coalesce?

1052


Define check constraint.

1075


List out the buffer pools in db2

1072


What is ibm db2 used for?

1074


How to execute stored procedures?

1129


How to get the ddl of a table in db2?

1127