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 does DML stand for and what are some examples of it?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
What will the COMMIT accomplish?
What is the function of logging in the db2 database?
what is the use of commit ? and what is the syntax?
what is check point and restart Logic ? why do we go for that ??
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
what is different three logs in DB2?
Which component is responsible for db2 startup and shutdown?
Is schema the same as database?
what is the difference between normal select query and currosor