How to define the data items to receive the fetch items for
the SQL?
Answer Posted / mehdee
Example:
EXEC SQL
FETCH AA_CURS
INTO :Host-name1, Host-name2, ...
EXEC-END
Note: Host-names listed are one to one related to the
Columns at DECLARE AA_CURS, and are INCLUDEed from it's
DB2 DECLGEN name in the program.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Give a brief description of db2 isolation levels?
What is the meaning concurrency in the db2 database?
What is image copy in db2?
How do I optimize a query 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?
Explain the contention situations caused by locks?
How does coalesce work?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What are the contents of a dclmgen?
Explain in detail about buffer manager and its functionalities?
What does reorg do in db2?
What is cursor in dbms?
What is the purpose of using commit?
What is the maximum size of varchar data type in db2?
How can record locking be achieved in those DB2 versions which do not support it?