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
11647 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 are the bind parameters ibm db2?

1055

How to create db2 table in mainframe?

1156

What is a bind card?

1221

How to connect to db2 database from windows command line?

1066

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1201

What are the benefits of using the db2 database?

1234

What does reorg do in db2?

1034

What is null in db2?

1029

What do you mean by cursor?

990

What is an instance in db2?

1039

What is the maximum length of sqlca?

1531

List some fields from sqlca?

1061

What is innodb buffer pool?

1063

What are bind parameters in db2?

1050

When reorg is used?

1133