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
Is schema the same as database?
How and when does the db2 enforces the unique key?
What is data manager?
What is drop table?
What is db2 connect?
What is db2 bind process?
How to run db2 command in windows?
What is with ur in db2?
What is catalog database in db2?
How to get the ddl of a table in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How is the value function used?
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 ?
What is the role of schema in the db2 database?
What is cursor stability in db2?
