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

vsam file access


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
owenthered

New User


Joined: 12 Aug 2022
Posts: 3
Location: us

PostPosted: Fri Aug 12, 2022 3:02 am
Reply with quote

all I have is ISPF, and need to view the structure of a VSAM and/or a row of data. Is there a way to do this. I can see DB2 tables, and would love to get to the vsam column names through a sql client or the 3270. thanks!
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2915
Location: NYC,USA

PostPosted: Fri Aug 12, 2022 6:28 am
Reply with quote

How about using any tools like fileaid or starttool?
Back to top
View user's profile Send private message
Willy Jensen

Active Member


Joined: 01 Sep 2015
Posts: 612
Location: Denmark

PostPosted: Fri Aug 12, 2022 5:41 pm
Reply with quote

A VSAM dataset contains records, pure and simple. Any structure that you apply to the records are your own responsibility.
DB2 has an separate directory which is used when accessing the records through DB2 services (I hope I got that right, I am not a DB2 person).
VSAM datasets can be browsed and edit from ISPF, if FileManager is installed and the access is enabled in the ISPF configuration table.
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 1564

PostPosted: Fri Aug 12, 2022 7:12 pm
Reply with quote

owenthered wrote:
all I have is ISPF, and need to view the structure of a VSAM and/or a row of data. Is there a way to do this. I can see DB2 tables, and would love to get to the vsam column names through a sql client or the 3270. thanks!


VSAM by itself has no information about the structure of its records, except the record size, and key length. This is full responsibility of the company, or the designer/developer who has created this VSAM file. There may be created (or not! when developers are lazy) the so called record layout definitions in the form of Assembler/COBOL/PLI copybooks.

ISPF by itself has no built-in tools to work with VSAM files. There are stand-alone tools, like FileManager, FileAid, and maybe others. Those tools may be installed (or not! if your System Administration is lazy) as part of your ISPF environment, and customized ISPF menus.

No forum outside of your organization can help you with this private issue of your company...
Back to top
View user's profile Send private message
owenthered

New User


Joined: 12 Aug 2022
Posts: 3
Location: us

PostPosted: Fri Aug 12, 2022 7:37 pm
Reply with quote

My only choices based on my login are the tso options 1-12. I don't know how to get into file aid but am thinking its not available. F or FA does nothing. I cant enter into CICS on the main entry page for my userid either. The other option is to select the VSAM from the data set utilities, but when I am in the IDCAMS screen no matter what I type the 3270 wants to access the non-vsam path. Maybe I need to type something for volume serial, or catalog the vsam first. I do have an alternate index set up if there was some way to see the vsam structure through that.
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 1564

PostPosted: Fri Aug 12, 2022 8:07 pm
Reply with quote

No forum outside of your organization can help you with this private issue of your company...
Back to top
View user's profile Send private message
dneufarth

Active User


Joined: 27 Apr 2005
Posts: 381
Location: Inside the SPEW (Cincinnati OH USA)

PostPosted: Fri Aug 12, 2022 9:20 pm
Reply with quote

Is there no one in your organization that can help you?

Reread sergeyken and willie jensen replies carefully.
Back to top
View user's profile Send private message
Willy Jensen

Active Member


Joined: 01 Sep 2015
Posts: 612
Location: Denmark

PostPosted: Fri Aug 12, 2022 10:16 pm
Reply with quote

Or you may use the TSO PRINT command, do TSO HELP PRINT for details, or refer to the TSO Commands Reference manual.
Back to top
View user's profile Send private message
Joerg.Findeisen

Active Member


Joined: 15 Aug 2015
Posts: 842
Location: Bamberg, Germany

PostPosted: Fri Aug 12, 2022 10:26 pm
Reply with quote

IDCAMS Repro should also be possible from within ISPF.
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 1564

PostPosted: Fri Aug 12, 2022 10:44 pm
Reply with quote

Joerg.Findeisen wrote:
IDCAMS Repro should also be possible from within ISPF.

The initial goal is
Quote:
need to view the structure of a VSAM and/or a row of data

IDCAMS can hardly help... 36_2_18.gif
Back to top
View user's profile Send private message
owenthered

New User


Joined: 12 Aug 2022
Posts: 3
Location: us

PostPosted: Fri Aug 12, 2022 11:44 pm
Reply with quote

Thanks for all the help. I will get file-aid attached to my login userid. It is available, but just not for my ID yet.
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 1564

PostPosted: Fri Aug 12, 2022 11:52 pm
Reply with quote

owenthered wrote:
Thanks for all the help. I will get file-aid attached to my login userid. It is available, but just not for my ID yet.


In order to view the "structure" of records (field-by-field), you may need besides of FileAid itself also the corresponding layout copybook(s) - either in COBOL, or PL/I. Assembler copybooks are not recognized by neither FileAid, nor FileManager...
Back to top
View user's profile Send private message
Willy Jensen

Active Member


Joined: 01 Sep 2015
Posts: 612
Location: Denmark

PostPosted: Sat Aug 13, 2022 2:17 pm
Reply with quote

You could try to browse a VSAM cluster to verify if browse/edit of VSAM from ISPF is enabled.
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Conditional replace values in output ... DFSORT/ICETOOL 3
No new posts COBOL - create and write to output fi... COBOL Programming 0
No new posts Inserting variable length into output... JCL & VSAM 2
No new posts Writing the output file name from a p... JCL & VSAM 7
No new posts Compare files with duplicates in one ... COBOL Programming 14
Search our Forums:

Back to Top