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
- 6515 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 |
What is db2 bind process?
how to take the back up of the DB2 table.
Can you define an Index if the table size less than 10 PAGES?
Mention the definition of cobol in varchar field.
What is a trigger in the db2 database?
what is difference between Static call and Dynamic call? How does it function?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Can you search give an array in the WHERE clause of a db2 query?
i have a db2 variable how do u declare tht into working storage section ?
what are stage one indexable predicates?
In which column of which DB2 catalog would you find the length of the rows for all tables?
COBOL 
