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
How to access db2 tables in mainframe?
What is db2 connect?
What are packages in db2?
What is package in db2 mainframe?
What is the difference between oracle and db2?
How to find primary key of a table in db2?
What is the physical storage length of date data type?
What is db2 bind process?
What is the latest version of ibm db2?
What is package in cobol db2?
What language is db2 written in?
How do I change the column size in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is multi row fetch in db2?
Explain about dbrm.