MAINFRAME - TIP OF THE DAY :
Q. If there is a situation, where we need to code more than 255 steps in a JOB?
A. We need to split jcl into two jcls , at the end of the first jcl check the condition code and initiate the second jcl.
Programmers Voted for below topics. Please Vote for good Posts.
Thank You! for your feedback. Connecting to the server. Please Wait...
Posted: Wed Oct 31, 2007 6:58 pm Post subject: cursors
I read some basics about cursors and i wanted to know in detail what a cursor does and what are row positoned ,row-set positioned cursors.
and also what r scrollable ,non-scrollable,held and non-held cursors .
I saw the mainframe manuals other than that any links .
Posted: Mon Dec 10, 2007 11:55 am Post subject: cursors
Cursor is a Progamming device which is used to retrieve one row at a time from the result of a select statement.
As Host language is capable of holding only one row at a time, and select is used in a cobol+db2 program which retreives multiple rows at a time, to bridge between these two conditions, cursor is used.
Cursor now takes each row from the result of a select statement and submits it to the host language. That is how cursor works. _________________ Regards,
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum