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 Testing rerad cursor for status with ... John F Dutcher DB2 8 Fri May 19, 2017 9:35 pm
No new posts Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
This topic is locked: you cannot edit posts or make replies. Cobol GUI (like Editor) Kala Mainframe COBOL Programming 14 Wed May 10, 2017 12:30 pm
No new posts IMS T-Pipe queue counts in a COBOL Pr... Siva NKK Kothamasu IMS DB/DC 0 Tue May 09, 2017 6:31 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm


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