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

Reading from master file and loading into DB2 table
IBM Mainframe Forums -> COBOL Programming
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
siddesh623

New User


Joined: 23 Aug 2007
Posts: 8
Location: Bangalore
PostPosted: Fri Aug 31, 2007 4:23 pm
 Reply with quote
Hi,

i am having a master file, in which a field occurs some 2 lakhs time and i want to read that field from master file and load it into DB2 table. is possible to declare any field i.e., occurs clause for some 2 lakhs times and i want some syntax to read the master file and load it into DB2 table


Pls send me as soon as possible
Back to top
View user's profile Send private message
ParagChouguley

Active User


Joined: 03 Feb 2007
Posts: 175
Location: PUNE(INDIA)
PostPosted: Fri Aug 31, 2007 4:44 pm
 Reply with quote
Hi,
Supposing that you want it to do in COBOL,
1. Read your master file sequentially.
2. Update your table thru SQL query for each read of file.

--Parag
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 -> COBOL Programming

 

Similar Topics
Topic Forum Replies
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 Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Load new table with Old unload - DB2 DB2 6
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us