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 the use of commit in db2?
What is precompiler in db2?
i want to maintain uniqueness on pdf without make lf??????????
What is the use of db2?
What is buffer pool and list some of them?
Explain about open switch business continuity software?
How and when does the db2 enforces the unique key?
What are bind parameters in db2?
What is bind package and plan in db2?
What is difference between isnull and coalesce?
Define check constraint.
List out the buffer pools in db2
What is ibm db2 used for?
How to execute stored procedures?
How to get the ddl of a table in db2?