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 How to display offset thru cobol prog... tvinodkumar7 CICS 1 Sun Apr 22, 2018 8:42 pm
No new posts Linkage editor is part of COBOL, z/OS... ankit.jain COBOL Programming 4 Fri Apr 20, 2018 4:17 pm
This topic is locked: you cannot edit posts or make replies. Difference between EQUAL and EQUAL TO... jithinraghavan COBOL Programming 3 Thu Apr 19, 2018 2:22 am
No new posts IDCAMS RENAMING VSAM FILE ALONG WITH ... upendrasri JCL & VSAM 11 Tue Apr 17, 2018 10:42 pm
No new posts Call COBOL or PLI with a click from w... vaibhav gs All Other Mainframe Topics 1 Mon Apr 16, 2018 7:29 pm

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