IBM MainFrame Question:

What does declare cursor and fetch cursor do?

Answer:

declare cursor does nothing, fetch cursor when excuted prepares all the resultset of query and place the control in first row.

Read All 28 IBM MainFrame Questions
Previous QuestionNext Question
How to fetch even records from one file to another file by using ICETOOL in JCL?When a db2 table is changed, how all impacted components are identified?