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

How to access db2 tables in mainframe?

1103


What is db2 connect?

1125


What are packages in db2?

1076


What is package in db2 mainframe?

1037


What is the difference between oracle and db2?

1173


How to find primary key of a table in db2?

1125


What is the physical storage length of date data type?

1308


What is db2 bind process?

1292


What is the latest version of ibm db2?

1338


What is package in cobol db2?

1163


What language is db2 written in?

1104


How do I change the column size in db2?

1208


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3206


What is multi row fetch in db2?

1103


Explain about dbrm.

1109