IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
 

Open, close & read the VSAM file using REXX

THIS IS AN ARCHIVE FORUM: CLICK HERE TO GO TO THE ORIGINAL TOPIC

 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> CLIST & REXX
View previous topic :: View next topic  
Author Message
muralithirumalaisamy



Joined: 13 Jun 2005
Posts: 10
Location: chennai
Posted: Tue Aug 12, 2008 5:20 pm    Post subject: Open, close & read the VSAM file using REXX  
Can anyone help me on giving the commands in REXX to open, close and read a VSAM file.

Thanks
Murali
Back to top  
Aaru



Joined: 03 Jul 2007
Posts: 1148
Location: Mumbai - India
Posted: Tue Aug 12, 2008 5:26 pm    Post subject: Reply to: how to open,close & read the VSAM file using R  
Murali,

Quote: Can anyone help me on giving the commands in REXX to open, close and read a VSAM file

You cannot deal with VSAM datasets directly in REXX. You will have to REPRO the vsam file to a sequential dataset and do the EXECIO operations on it.

Also search this forum for VSAM for similar topics.
Back to top  
superk



Joined: 26 Apr 2004
Posts: 3304
Location: Charlotte,NC USA
Posted: Tue Aug 12, 2008 6:10 pm    Post subject: Reply to: Open, close & read the VSAM file using REXX  
See some of these previous topics:

http://www.ibmmainframes.com/viewtopic.php?t=29638
http://www.ibmmainframes.com/viewtopic.php?t=24906
http://www.ibmmainframes.com/viewtopic.php?t=22770
Back to top  
agkshirsagar



Joined: 27 Feb 2007
Posts: 569
Location: Mumbai,India
Posted: Tue Aug 12, 2008 6:11 pm    Post subject:  
http://www.ibmmainframes.com/viewtopic.php?t=29638

This link points to a similar topic discussed on the forum. This may help.
Back to top  
Anuj D.



Joined: 22 Apr 2006
Posts: 2229
Location: Phoenix, AZ
Posted: Tue Aug 12, 2008 6:20 pm    Post subject:  
Hi,

I'm just starting with REXX. However, unless things have been changed recently, there isn't a way to do it with native REXX.

You may want to check out REXX/Tools by a company called Open Software Technologies

http://www.open-softech.com/

And as Aaru said, a simple solution is to use REPRO. This code reads on record from a VSAM parameter file. Somethinf like -

Code:  ADDRESS TSO ,
   "ALLOCATE FILE(TEMPDD) NEW SPACE(1) TRACKS DSORG(PS) RECFM(F,B),
     LRECL(139) BLKSIZE(27939)"

  ADDRESS TSO ,
   "REPRO INFILE("VSAM_file") OUTFILE("Seq_file") COUNT(1)"

  ADDRESS TSO ,
   "EXECIO 1  DISKR" Seq_file "(FINIS STEM Param_data."
Back to top  
Garry Carroll



Joined: 08 May 2006
Posts: 171
Location: Dublin, Ireland
Posted: Tue Aug 12, 2008 7:06 pm    Post subject:  
Try googling RXVSAM

Garry.
Back to top  
dick scherrer



Joined: 23 Nov 2006
Posts: 8733
Location: 221 B Baker St
Posted: Tue Aug 12, 2008 9:21 pm    Post subject:  
Hello,

If your vsam file is large (say several million records), copying it to a qsam file just to make the data available to rexx sounds like a questionable (at best) idea. This will waste considerable system cycles as well as a bunch of dasd. . .

Maybe that data should not be processed by rexx directly? Maybe rexx could call some "service module" (cobol?) and read the necessary record(s) passing back the needed info to rexx.
Back to top  
 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> CLIST & REXX
Page 1 of 1
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM