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
11605 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 the use of db2?

1046

What does a deadlock mean in DB2?

1158

Is db2 a mainframe?

1037

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

1264

Mention the definition of cobol in varchar field.

1238

What is a trigger in the db2 database?

1066

What is the physical storage length of date data type?

1246

How to retrieve rows from a db2 table in embedded sql?

1378

What is the connection string to connect to the DB2 Database ?

1111

What is dclgen in db2?

1135

What are packages in db2?

1019

What is package in db2 mainframe?

979

What is difference between alias and synonym in db2?

1131

What is dbrm? When it will be created?

1020

What is the use of db2 optimizer?

1102