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
 

 

Can we access vsam file from clist?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
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    Post subject: Can we access vsam file from clist?
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: 6968
Location: porcelain throne

PostPosted: Tue Jan 20, 2009 7:58 pm    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Tue Jan 20, 2009 8:03 pm    Post subject:
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

Active Member


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

PostPosted: Tue Jan 20, 2009 8:35 pm    Post subject:
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: 6968
Location: porcelain throne

PostPosted: Tue Jan 20, 2009 8:38 pm    Post subject:
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    Post subject: Reply to: Can we access vsam file from clist?
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

Site Director


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

PostPosted: Wed Jan 21, 2009 10:02 am    Post subject:
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    Post subject:
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

Moderator Team Head


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

PostPosted: Wed Jan 21, 2009 12:18 pm    Post subject: Reply to: Can we access vsam file from clist?
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: 8593
Location: Back in jolly old England

PostPosted: Wed Jan 21, 2009 12:24 pm    Post subject:
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    Post subject: Reply to: Can we access vsam file from clist?
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: 8593
Location: Back in jolly old England

PostPosted: Wed Jan 21, 2009 1:40 pm    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Wed Jan 21, 2009 3:41 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts How to generate a new unique Input fi... for1ranjith CLIST & REXX 11 Sat Jul 01, 2017 12:09 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm


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