What is the purpose of coding FETCH in a SQL SELECT query?
Explain with an example in Detail?
Answer Posted / akviswa
PS: fetch can be used in select only in case of cursor
select
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is the use of runstats in db2?
Explain about dbrm.
Can we insert update delete in view?
How will you return the number of records in table?
what are bind concepts in db2 cobol?
What is null indicator in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What are the prerogatives?
What are bind parameters in db2?
What is db2?
What does runstats do in db2?
How to rename a table in DB2 ?
What is meant by dclgen?
What is copy pending status in db2?