Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
REXX VSAM

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
View previous topic :: :: View next topic  
Author Message
Harold Barnes

New User


Joined: 27 Oct 2015
Posts: 17
Location: United States

PostPosted: Sat Oct 05, 2019 2:38 pm    Post subject: REXX VSAM
Reply with quote

I've recently discovered the world of REXX VSAM and FILEMGR.
I've successfully populated a VSAM file using FILEMGR with STEM.
I've successfully read the data with FILEMGR and STEM.

Very cool!

I would like to use REXX to query my new VSAM file with a key and get a record. Maybe using FILEMGR FCH or something else?

Maybe there is a non-FILEMGR solution?

I've been googling and haven't found a solution. I'm ready to be enlightened by the gurus.
Back to top
View user's profile Send private message

Harold Barnes

New User


Joined: 27 Oct 2015
Posts: 17
Location: United States

PostPosted: Sat Oct 05, 2019 3:51 pm    Post subject: REXX VSAM
Reply with quote

I found an example of using "REPRO" with FROMKEY to write to a temp file and then used "EXECIO" to read the file into a STEM variable.

That worked. icon_biggrin.gif

I tried another example using OUTTRAP and "PRINT" but got RACF'd icon_mad.gif

Is there a better way?
Back to top
View user's profile Send private message
Willy Jensen

Active User


Joined: 01 Sep 2015
Posts: 317
Location: Denmark

PostPosted: Sat Oct 05, 2019 4:02 pm    Post subject:
Reply with quote

Two free REXX VSAM acess programs springs to mind:
RXVSAMBA from CBTTAPE.ORG file file 669 and http://harders-jensen.com/wjtech/zprograms.html (newest). This one reads and writes multiple records to/from stem or stack with optional filtering.
RXVSAM from CBTTAPE.ORG file 268 does single record access.
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 -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Running a REXX exec program using ZOSMF Sakthi344 CLIST & REXX 1 Tue Oct 15, 2019 3:13 pm
No new posts REXX for Reading SMF type 70-1 AdrielGB Testing & Performance analysis 6 Sat Oct 05, 2019 3:03 am
No new posts Can GLobal variable used under TSOE/REXX Kaliragavendran CLIST & REXX 5 Tue Sep 24, 2019 7:16 am
No new posts REXX and 3270 highlighting Harold Barnes CLIST & REXX 3 Fri Sep 20, 2019 5:26 am
No new posts REXX EXECIO STEM No newline Harold Barnes CLIST & REXX 3 Tue Sep 17, 2019 6:07 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us