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

Can we access vsam file from clist?


IBM Mainframe Forums -> TSO/ISPF
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sampathkmn
Warnings : 1

New User


Joined: 12 Dec 2005
Posts: 31
Location: bangalore

PostPosted: Tue Jan 20, 2009 7:50 pm
Reply with quote

Hi,

Can we access vsam file using clist. If yes, is it there any sysnax change as compared to access of nonvsam files using clist?

Thanks,
Sampath
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Jan 20, 2009 7:58 pm
Reply with quote

as of this moment, CLIST has no access.
Rexx, as delivered by IBM, has no direct vsam abillities.

there is a module (search the forum) that can be obtained free on the web, REXXVSAM (I think).
This can be CALLed from a rexx script (maybe even CLIST)

I would suggest that you forget CLIST and learn/use REXX.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Tue Jan 20, 2009 8:03 pm
Reply with quote

You can invoke IDCAMS and perform extremely basic tasks such as retrieve a record by key and then replace it in the KSDS.

Apart from that, nothing else.
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 Jan 20, 2009 8:35 pm
Reply with quote

Quote:
REXXVSAM (I think).


RXVSAM , actually.

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

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Jan 20, 2009 8:38 pm
Reply with quote

Thx Garry.
Back to top
View user's profile Send private message
sampathkmn
Warnings : 1

New User


Joined: 12 Dec 2005
Posts: 31
Location: bangalore

PostPosted: Wed Jan 21, 2009 9:36 am
Reply with quote

thanks for the response.
with these response can i conclude that vsam access using CLIST not possible?
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: Wed Jan 21, 2009 10:02 am
Reply with quote

Hello,

Quote:
with these response can i conclude that vsam access using CLIST not possible?
Why would you believe this? You were told about reading/updating via idcams as well as the possibility that rxvsam might do what you need.

Whether you can successfully use these depends on your requirement which you have not described.
Back to top
View user's profile Send private message
sampathkmn
Warnings : 1

New User


Joined: 12 Dec 2005
Posts: 31
Location: bangalore

PostPosted: Wed Jan 21, 2009 11:52 am
Reply with quote

My Requirement is as follows:

I use a vsam KSDS as input which will be opened in i-o mode(read and update). The vsam has to be read useing key field which comes from a screen using clist.
If key is found in vsam display the record on screen where nuser will have option to edite the data, and then same data is updated in vsam file.

i guess this data is sufficient, everything needs to be handled in clist.
Back to top
View user's profile Send private message
superk

Global Moderator


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

PostPosted: Wed Jan 21, 2009 12:18 pm
Reply with quote

Why can't this process be coded in COBOL?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Wed Jan 21, 2009 12:24 pm
Reply with quote

Please read my previous reply to your topic.
Back to top
View user's profile Send private message
sampathkmn
Warnings : 1

New User


Joined: 12 Dec 2005
Posts: 31
Location: bangalore

PostPosted: Wed Jan 21, 2009 1:24 pm
Reply with quote

Can you please send me sample code to invoke IDCAMS from clist?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Wed Jan 21, 2009 1:40 pm
Reply with quote

It's over 15 years since I've even looked at a CLIST, and I'm not going to start ploughing through the manuals now icon_lol.gif

I might have some REXX code that does the same sort of thing. Will post it if I can find it.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Wed Jan 21, 2009 3:41 pm
Reply with quote

The REPRO statement is supported in REXX so should be in CLIST too
Code:

" REPRO IFILE(KSDSIN) OFILE(WORK) FROMKEY("KEYIN") TOKEY("KEYIN")"

So by building the command above, using REXX, it is also executed.
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 -> TSO/ISPF

 


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 Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top