Interested to Buy Any Domain ? << Click Here >> for more details...
what is the total syntax for fetch ? can any one please give
me all the details of fetch ? thx
- 2 Answers
- 6317 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pandu
Exec SQL
Fetch<cursorname> into :<host variables>
End-exec.
correct me is am wrong?
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / sree
YES THE ABOVE SYNTAX IS CORRECT
IF THERE ARE MORE THAN ONE HOSTVARIABLES,IE IF THERE ARE
MORE COLUMNS IN THE DB2 TABLE
SYNTAX IS
EXEC SQL
FETCH CURSORNAME INTO :HOSTVARIABLE1 ,
:HOSTVARIABLE2 ,
---
---
:HOSTVARIABLEN
END-EXEC
| Is This Answer Correct ? | 11 Yes | 0 No |
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the difference between nvl and coalesce?
What is an intent lock?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
How many Buffer pools are there in DB2 and what are they?
How do I add a column to an existing table in db2?
Can we delete records from view?
What is difference between rollback and commit?
Once you create a view, where would information about the view be stored?
When is the access path determined for dynamic SQL?
COBOL 
