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 is cursor with hold option in db2?

622


How many types of page locks can be held in db2?

603


Mention the different locking levels that are available in db2.

657


What is deadlock in db2?

589


How do I copy a table in db2?

583






Give a brief description of db2 isolation levels?

615


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

599


Is it possible using max on a char column?

615


What is ibm db2 connect?

585


What is dbrm? When it will be created?

608


How do I add a column in db2?

604


what is db2 restart?

1701


What is bind package and plan in db2?

606


What is the result of open cursor statement?

644


What is the picture clause of null indicator variable?

705