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

Program to load a table from DB2 to a vsam file


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

New User


Joined: 15 Jul 2006
Posts: 1

PostPosted: Sun Aug 06, 2006 9:07 pm
Reply with quote

Can anyone help me in writing a program in cobol to load a table from db2 to a vsam file.
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Mon Aug 07, 2006 2:13 am
Reply with quote

Daman,

Firstly you'll have to verify if record lay-out is same for VSAM File and DB2 Table or not.

If yes, you can simply READ and INSERT the table. But if you have some utility to load DB2 table, that would be more performance oriented.

Better to get in touch with your site- DBA, who would be the most appropriate person to ask your doubt.
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 FTP VB File from Mainframe retaining ... JCL & VSAM 1
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 Using API Gateway from CICS program CICS 0
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top