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

Why db2 is called db2?

797


Explain correlated sub-queries.

792


What is check constraint. Explain with example.

872


How can you quickly find out the # of rows updated after an update statement?

823


Which isolation level provides highest data integrity?

834


Why do we need reorg in db2?

760


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1855


Explain about rct.

877


What are the different types of base tables?

795


What is buffer pool?

874


What is query_cache_limit?

782


What is cursor with hold option in db2?

838


Can we insert update delete in view?

770


What is a bind in db2?

787


What is cascading rollback?

879