IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Open, close & read the VSAM file using REXX


IBM Mainframe Forums -> CLIST & REXX
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
muralithirumalaisamy
Warnings : 1

New User


Joined: 13 Jun 2005
Posts: 12
Location: chennai

PostPosted: Tue Aug 12, 2008 5:20 pm
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
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Tue Aug 12, 2008 5:26 pm
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

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Tue Aug 12, 2008 6:10 pm
Reply with quote

See some of these previous topics:

www.ibmmainframes.com/viewtopic.php?t=29638
www.ibmmainframes.com/viewtopic.php?t=24906
www.ibmmainframes.com/viewtopic.php?t=22770
Back to top
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 691
Location: Earth

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

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 Dhawan

Superior Member


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

PostPosted: Tue Aug 12, 2008 6:20 pm
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

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

Senior Member


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

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

Try googling RXVSAM

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

Moderator Emeritus


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

PostPosted: Tue Aug 12, 2008 9:21 pm
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CLIST & REXX

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Compile Several JCL JOB Through one r... CLIST & REXX 4
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
Search our Forums:

Back to Top