Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the table is empty or not?
- 3 Answers
- 11614 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
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 |
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 |
How can you quickly find out the # of rows updated after an update statement?
WHAT IS MEANT BY COMMIT COMMAND?
What is the latest version of ibm db2?
When Can you be sure that a query will return only one row?
What does an outer join do?
How do you find the maximum value in a column in db2?
What types of tables are there in the db2 database?
What is reorg?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
What is the self-referencing constraint?
What is a buffer in memory?
What is the maximum size of varchar data type in db2?
COBOL 
