Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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
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    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

Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
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: 4650
Location: Raleigh, 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

Active Member


Joined: 27 Feb 2007
Posts: 686
Location: Earth

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 Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
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 Member


Joined: 08 May 2006
Posts: 998
Location: Dublin, Ireland / Edinburgh, Scotland

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

Site Director


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

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
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 How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
This topic is locked: you cannot edit posts or make replies. Rexx to execute spool commands upendrasri CLIST & REXX 5 Wed Oct 04, 2017 6:54 am
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm

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