View previous topic :: View next topic
|
Author |
Message |
owenthered
New User
Joined: 12 Aug 2022 Posts: 3 Location: us
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3053 Location: NYC,USA
|
|
|
|
How about using any tools like fileaid or starttool? |
|
Back to top |
|
|
Willy Jensen
Active Member
Joined: 01 Sep 2015 Posts: 712 Location: Denmark
|
|
|
|
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 |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2023 Location: USA
|
|
|
|
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 |
|
|
owenthered
New User
Joined: 12 Aug 2022 Posts: 3 Location: us
|
|
|
|
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 |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2023 Location: USA
|
|
|
|
No forum outside of your organization can help you with this private issue of your company... |
|
Back to top |
|
|
dneufarth
Active User
Joined: 27 Apr 2005 Posts: 420 Location: Inside the SPEW (Southwest Ohio, USA)
|
|
|
|
Is there no one in your organization that can help you?
Reread sergeyken and willie jensen replies carefully. |
|
Back to top |
|
|
Willy Jensen
Active Member
Joined: 01 Sep 2015 Posts: 712 Location: Denmark
|
|
|
|
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 |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015 Posts: 1255 Location: Bamberg, Germany
|
|
|
|
IDCAMS Repro should also be possible from within ISPF. |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2023 Location: USA
|
|
|
|
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... |
|
Back to top |
|
|
owenthered
New User
Joined: 12 Aug 2022 Posts: 3 Location: us
|
|
|
|
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 |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2023 Location: USA
|
|
|
|
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 |
|
|
Willy Jensen
Active Member
Joined: 01 Sep 2015 Posts: 712 Location: Denmark
|
|
|
|
You could try to browse a VSAM cluster to verify if browse/edit of VSAM from ISPF is enabled. |
|
Back to top |
|
|
|