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

convertion from vsam file to a flat file


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
katherine-norada

New User


Joined: 29 Jan 2007
Posts: 1
Location: philippines

PostPosted: Mon Jan 29, 2007 8:01 am
Reply with quote

hi there!

i hope you can help me on how to convert a vsam file to a flat file.


thanks,
kat
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Jan 29, 2007 9:52 am
Reply with quote

Hello,

If you want a sequential copy of the VSAM file, use the IDCAMS utility REPRO.

If you need some other kind of conversion, please specify.
Back to top
View user's profile Send private message
RKT

New User


Joined: 06 Nov 2006
Posts: 4

PostPosted: Mon Apr 23, 2007 11:00 pm
Reply with quote

Any chance that you could throw together some JCL that works for a VSE system?

Thank you.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Mon Apr 23, 2007 11:38 pm
Reply with quote

RKT wrote:
Any chance that you could throw together some JCL that works for a VSE system?
Any chance you look at the IDCAMS manual and find an example that works?
Back to top
View user's profile Send private message
RKT

New User


Joined: 06 Nov 2006
Posts: 4

PostPosted: Mon Apr 23, 2007 11:56 pm
Reply with quote

I've been trying to locate a manual with examples to no avail.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Tue Apr 24, 2007 12:08 am
Reply with quote

RKT wrote:
I've been trying to locate a manual with examples to no avail.
Which manual, IDCAMS or VSE JCL?
Back to top
View user's profile Send private message
RKT

New User


Joined: 06 Nov 2006
Posts: 4

PostPosted: Tue Apr 24, 2007 12:12 am
Reply with quote

I would say IDCAMS for VSE if such a beast exists
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Apr 24, 2007 1:08 am
Reply with quote

Hello,

This is available from IBM:

Quote:
The IDCAMS utility program is part of IBM VSE/VSAM. Use IDCAMS commands to define VSE/VSAM files, catalog such files, and request many other IDCAMS functions:

Establish catalog(s)
Create data spaces
Create VSE/VSAM files and load records into the files
Build an alternate index for a file
Create backup copies of files and their associated catalog entries
Print, copy, or reorganize files
Delete files, data spaces, and catalogs
Alter file definitions and file attributes
Print catalog entries
Move catalogs and files from one system to another
Convert nonVSAM files to VSE/VSAM files
Recover from damage to files or catalogs
Verify command syntax
Merge two VSE/VSAM files


While not specified in that list, there is much about REPRO in that manual.

It is from the "VSE/VSAM V6R4 User's Guide and Application Programming" manual. If i've done this correctly, the link is
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IESVGE00/CCONTENTS?SHELF=EZ2ZVM00&DN=SC33-6732-00&DT=19990426211356

If i've messed up, this is the publication number - SC33-6732-00.

Good luck icon_smile.gif
Back to top
View user's profile Send private message
RKT

New User


Joined: 06 Nov 2006
Posts: 4

PostPosted: Tue Apr 24, 2007 1:26 am
Reply with quote

Thank you very much.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Tue Apr 24, 2007 1:33 am
Reply with quote

If you don't already have it, Loading Records into a File and Example 5: Loading and Printing of Files should give you a handle......
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 -> JCL & VSAM

 


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 SFTP Issue - destination file record ... All Other Mainframe Topics 2
Search our Forums:

Back to Top