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 db2 optimizer?
Mention the downsides of page level lock.
What is a Foreign Key?
What action db2 takes when a program aborts in the middle of a transaction?
What is load utility in db2?
How do I copy a table in db2?
What is db2 instance?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is check constraint in db2?
What is load replace in db2?
What is db2 look?
What are types of indexes?
How will you return the number of records in table?
How do I change the column size in db2?
Explain the contents that are a part of dclgen.
