View previous topic :: View next topic
|
Author |
Message |
Harold Barnes
New User
Joined: 27 Oct 2015 Posts: 33 Location: United States
|
|
|
|
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 |
|
|
Harold Barnes
New User
Joined: 27 Oct 2015 Posts: 33 Location: United States
|
|
|
|
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.
I tried another example using OUTTRAP and "PRINT" but got RACF'd
Is there a better way? |
|
Back to top |
|
|
Willy Jensen
Active Member
Joined: 01 Sep 2015 Posts: 712 Location: Denmark
|
|
|
|
Two free REXX VSAM acess programs springs to mind:
RXVSAMBA from CBTTAPE.ORG file file 669 and 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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
I've always used the REPRO FROMKEY TOKEY option.
Slow but effective.
SAS if you have it is quite good for VSAM too |
|
Back to top |
|
|
|