EXEC-SQL SELECT 1 INTO :X FROM TAB1 END-EXEC X is defined as s9

how to check the table is empty or not?

Question Posted / sriram

3 Answers
11787 Views
IBM, I also Faced
E-Mail Answers

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 runstats utility in db2?

1070

What type of database is db2?

1019

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1322

What is the syntax for creating a table in the db2 database?

1150

what are bind concepts in db2 cobol?

1138

Which isolation level provides highest data integrity?

1189

What is meant by dclgen?

1173

What is db2 optimizer?

1313

B37 abend during spufi?

1511

How do you stop a db2 database in linux?

1059

Name the lockable units in DB2?

1188

What is dbrm?

1179

What types of tables are there in the db2 database?

1101

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

3010

What is null indicator in cobol db2?

1111