Interested to Buy Any Domain ? << Click Here >> for more details...
How to define the data items to receive the fetch items for
the SQL?
- 2 Answers
- 5916 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sadiq afroze
Using the DSECT, followed by lines of - 'data items DS
datatype'.
| Is This Answer Correct ? | 0 Yes | 2 No |
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is a DB2 bind?
What is the difference between cursor stability and repeatable read isolation levels?
How to fetch the uncommited data from table ?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What is the use of db2?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
What happens to a cursor after a commit?
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 can the Locate option of the Repair Utility accomplish?
What is a DBRM, PLAN ?
What is ibm db2 connect?
COBOL 
