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
- 6315 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 do I delete a table in db2?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
What is JOIN and different types of JOIN.
How would the varchar column remarks defined?
wht happens if we close cursor with cursor with hold option?
What is the difference between drop table and delete table?
how can u nderstand the sql stmts executed successfully or not ?
What is a DB2 access path?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
Which catalog tables contain authorization information?
COBOL 
