Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us