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 is the use of with ur in db2?
Mention the location where the output received from explain statement is stored.
How do I delete a column in db2?
How can you quickly find out the # of rows updated after an update statement?
What are bind parameters in db2?
What is null indicator in db2?
What is runstats db2?
What is the max length of sqlca?
List out the three types of page locks that can be held.
What is innodb buffer pool?
What is the latest version of ibm db2?
How to get the ddl of a table in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
what is a corelated subquerry?
What is the reason behind not using select * in embedded sql programs?
