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 maximum number of columns in a db2 table?
What is the role of the data page in the db2 database?
What db2 400?
What is node in db2?
What is the use of predicate?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How do I copy a table in db2?
What is database reorganization?
Explain what are the various isolation levels possible?
What is concurrency?
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 are catalog tables in db2?
What is a collection in db2?
What is the difference between spufi and qmf?
What is the physical storage length of the data types date, time, and timestamp?
