what is the total syntax for fetch ? can any one please give
me all the details of fetch ? thx
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 |
What is the syntax for creating a table in the db2 database?
What are column-name qualifiers used?
how to copy the host variables from ps file into cobol program other than include statement
What is cursor stability in db2?
wht displays the number of times a query modified ?
How can you classify the locks in db2?
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
why we go for SPUFI for creating tables or for sql queries?
Write a query to retrive partial string.
what is rebinding ?
What is a clustering index?
Which catalog table stores referential constraints?