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
11624 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 release/acquire in bind?

1102

What is a db2 table?

1009

What is bind package and plan in db2?

1053

What is dbrm? When it will be created?

1022

Is schema the same as database?

1053

Explain dclgen.

1197

what is a corelated subquerry?

1121

What is collection in db2 bind?

1011

What parameters are used to control the free space in DB2?

1055

What is the use of db2?

1051

List some fields from sqlca?

1056

What is temporal table in db2?

1035

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1270

How do I copy a table in db2?

996

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

1273