What is the purpose of coding FETCH in a SQL SELECT query?
Explain with an example in Detail?
Answer Posted / guest
FETCH is used to retrieve a specific row from a result set
of the SELECT query and places them into local variables.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to check last update on table in db2?
What is runstats and reorg in db2?
What do you mean by storage group (stogroup)?
What are the prerogatives?
What is with ur in db2?
How to find schema of a table in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is the role of the data page in the db2 database?
How to execute stored procedure in db2 command editor?
What is db2 stogroup?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Mention some fields that are a part of sqlca.
What is a cursor in programming?
What is the information associated with sysibm.syslinks table?
What does a deadlock mean in DB2?