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
- 6417 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 the SQL Communications Area and what are some of its key fields?
Why select is not preferred in embedded sql programs?
What information is contained in a SYSCOPY entry?
What is dclgen in db2?
What will the FREE command do to a plan?
What os does db2 run on?
what is cursor stability?
What is a cursor and what is its function?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
Define db2.
What is the usage of open cursor command?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
COBOL 
