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
- 6280 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 |
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
what is the name of the default db2 catalog database?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
wht happens if we close cursor with cursor with hold option?
What is -904 sql code? How to resolve it?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
How can you display the current date & current time ?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
How do you Load a table ?? and what is Load replace ?
What is a subselect? Is it different from a nested select?
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
COBOL 
