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
Explain about dbrm.
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is deadlock in db2?
Can we insert update delete in view?
How will you return the number of records in table?
Give the name of some fields form sqlca.
What is reorg?
Define sqlca.
What is innodb buffer pool?
What os does db2 run on?
What is cursor in dbms?
What is difference between isnull and coalesce?
What is clone table?
How can we read records for specific member in CL? AND rpg?
What's The Percentage Free Space ?
