Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DB2 Cursor-COBOL application-Flat file[A cycle 2 pfm a task]

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
AnuB
Currently Banned

New User


Joined: 29 Aug 2005
Posts: 35

PostPosted: Tue Sep 13, 2005 7:18 pm    Post subject: DB2 Cursor-COBOL application-Flat file[A cycle 2 pfm a task]
Reply with quote

?When u r trying to retrieve some rows from DB2 table into ur application , say using a cursor then during which part of the cycle of the cursor does the task actually takes place ?(open, fetch, close, or after close , WHEN ?)i.e, when u practically get the data in the form of rows into ur application & how ?

?Now when u have retrived the data how will u put in a flat file.

?Will u open a new file for it or in the same file u read and write, how u achieve it ? Pls explain me theoretically and also with an example of code.

?How will u confirm whether all the required records have been copied properly,

And how can we achieve the whole above process vice-versa ,i.e, from a flat file to DB2.

Pls help me.
Back to top
View user's profile Send private message

Ajit

New User


Joined: 06 Sep 2005
Posts: 3
Location: Bangalore

PostPosted: Wed Sep 14, 2005 12:15 pm    Post subject: cursor
Reply with quote

1. During opening of the cursor data will be stored into temporery set in main memory. then fetch each row from temporery set and populate into host variables.

2. now data is there in host variables so move those data to working storage variable of record layout of the file.
Back to top
View user's profile Send private message
AnuB
Currently Banned

New User


Joined: 29 Aug 2005
Posts: 35

PostPosted: Tue Sep 20, 2005 1:00 am    Post subject: Thanks
Reply with quote

Thanks.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts COB2 file processing rizwanaccy COBOL Programming 8 Tue Jan 02, 2018 1:00 pm
No new posts Migrating Java application from JVM p... danik56 CICS 0 Sat Dec 23, 2017 1:42 pm
No new posts KSDS and Index file in cobol deepak14450 COBOL Programming 9 Fri Dec 22, 2017 9:36 am
No new posts Preserve order in Input File pshongal DFSORT/ICETOOL 13 Thu Dec 21, 2017 4:20 pm
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us