Interested to Buy Any Domain ? << Click Here >> for more details...
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 do you mean by commit and rollback?
How to execute stored procedures?
what is diffrence b/w file-aid tool and file-aid utility???
What is bind in db2?
Which isolation level provides maximum concurrency?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the difference between dbm cfg and db cfg file in db2 ?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is db2 stogroup?
Define data page.
How do I create a view in db2?
What is copy pending and check pending in db2?
What is database alias db2?
What is check constraint. Explain with example.
What is phantom read in db2?
