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
What is db2? Explain.
What is isolation level in db2?
What is a trigger in the db2 database?
What is reorg and runstats in db2?
What is temporal table in db2?
Explain the contents that are a part of dclgen.
Explain the function of data manager.
Is it possible using max on a char column?
How to rename a table in DB2 ?
What is cloudant database?
What is a db2 table?
What is db2 bind process?
What is a db2 schema?
How connect db2 database to datastage?
List out the data types available.
