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
 

 

convertion from vsam file to a flat file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: convertion from vsam file to a flat file
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

Site Director


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

PostPosted: Mon Jan 29, 2007 9:52 am    Post subject:
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    Post subject: Re: convertion from vsam file to a flat file
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: 3158
Location: Tucson AZ

PostPosted: Mon Apr 23, 2007 11:38 pm    Post subject: Re: convertion from vsam file to a flat file
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    Post subject: Re: convertion from vsam file to a flat file
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: 3158
Location: Tucson AZ

PostPosted: Tue Apr 24, 2007 12:08 am    Post subject: Re: convertion from vsam file to a flat file
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    Post subject: Re: convertion from vsam file to a flat file
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

Site Director


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

PostPosted: Tue Apr 24, 2007 1:08 am    Post subject:
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    Post subject: Re: convertion from vsam file to a flat file
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: 3158
Location: Tucson AZ

PostPosted: Tue Apr 24, 2007 1:33 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fail to change physical VSAM filename... jacobdng CICS 0 Fri Jan 20, 2017 12:36 pm
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm


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