Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Open, close & read the VSAM file using REXX

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
Author Message
muralithirumalaisamy
Warnings : 1

New User


Joined: 13 Jun 2005
Posts: 12
Location: chennai

PostPosted: Tue Aug 12, 2008 5:20 pm    Post subject: Open, close & read the VSAM file using REXX
Reply with quote

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

Thanks
Murali
Back to top
View user's profile Send private message
References
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1252
Location: Chennai - India

PostPosted: Tue Aug 12, 2008 5:26 pm    Post subject: Reply to: how to open,close & read the VSAM file using R
Reply with quote

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
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 3383
Location: Charlotte,NC USA

PostPosted: Tue Aug 12, 2008 6:10 pm    Post subject: Reply to: Open, close & read the VSAM file using REXX
Reply with quote

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
View user's profile Send private message
agkshirsagar

Senior Member


Joined: 27 Feb 2007
Posts: 578
Location: Mumbai,India

PostPosted: Tue Aug 12, 2008 6:11 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Anuj D.

Global Moderator


Joined: 22 Apr 2006
Posts: 2353
Location: Mumbai, India

PostPosted: Tue Aug 12, 2008 6:20 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Garry Carroll

Active User


Joined: 08 May 2006
Posts: 192
Location: Dublin, Ireland

PostPosted: Tue Aug 12, 2008 7:06 pm    Post subject:
Reply with quote

Try googling RXVSAM

Garry.
Back to top
View user's profile Send private message
dick scherrer

Global Moderator


Joined: 23 Nov 2006
Posts: 9210
Location: 221 B Baker St

PostPosted: Tue Aug 12, 2008 9:21 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1