IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 Cursor-COBOL application-Flat file[A cycle 2 pfm a task]


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
AnuB
Currently Banned

New User


Joined: 29 Aug 2005
Posts: 33

PostPosted: Tue Sep 13, 2005 7:18 pm
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
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: 33

PostPosted: Tue Sep 20, 2005 1:00 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Replace each space in cobol string wi... COBOL Programming 3
Search our Forums:

Back to Top