Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ 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
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: 4648
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: 685
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: 991
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 recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts REXX DB2: Dynamic allocation of DB2.D... BHAS CLIST & REXX 3 Mon Dec 19, 2016 8:26 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us