IBM MainFrame Question:

What does declare cursor and fetch cursor do?

IBM MainFrame Interview Question
IBM MainFrame Interview Question

Answer:

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


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?