View previous topic :: View next topic
|
Author |
Message |
satish.ms10
Active User
Joined: 10 Aug 2009 Posts: 184 Location: India
|
|
|
|
Hi All,
Do we have any system command in Mainframe, like DSPFD command in AS/400, to get the file description details like Type of file, keyed/non-keyed, Unique key(yes/no), No of key fields, Name of key fields, Record length, Row count, Total size etc..
Do we have any command to get the field description of a file, like DSPFFD command in AS/400.
To get the details like Field Name, Field Type, Field Length, Decimal position, Field description, Unique(yes/no) etc...
Can someone help me in this regard.
Thanks in advance. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3053 Location: NYC,USA
|
|
|
|
We use a tool to view it with corresponding copybook mapping but few of it can also be looked using by 'I' and LISTCAT. |
|
Back to top |
|
|
steve-myers
Active Member
Joined: 30 Nov 2013 Posts: 917 Location: The Universe
|
|
|
|
In standard TSO you have the LISTDS command -
Code: |
listd 'sys1.maclib'
SYS1.MACLIB
--RECFM-LRECL-BLKSIZE-DSORG
FB 80 6160 PO
--VOLUMES--
XXXXXX |
The amount of output, as you can see, is minimal. Many shops have an enhanced LISTDS command of some sort, though I'm not aware of anything that is generally available.
ISPF has a facility to display data set information. It produces output like this -
Code: |
Data Set Information
Command ===>____________________________________________________
Data Set Name . . . : SYS1.MACLIB
General Data Current Allocation
Volume serial . . . : XXXXXX Allocated cylinders : 183
Device type . . . . : 3390 Allocated extents . : 1
Organization . . . : PO Maximum dir. blocks : 200
Record format . . . : FB
Record length . . . : 80
Block size . . . . : 6160 Current Utilization
1st extent cylinders: 183 Used cylinders . . : 183
Secondary cylinders : 5 Used extents . . . : 1
Used dir. blocks . : 111
Creation date . . . : 2001/04/03 Number of members . : 1,716
Referenced date . . : 2014/09/24
Expiration date . . : ***None*** |
Notice that neither facility provides information about fields in the data set. That's because that information is not a data set attribute. Only the programs that use the data set have this information. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
There are various ways, as indicated, to get data about a data set on a mainframe. There is nothing that will give you data about the fields in the data set as field information is not stored anywhere on a mainframe -- it is not an AS/400. You need to consult application documentation, or read the code, to determine field attributes. |
|
Back to top |
|
|
Pete Wilson
Active Member
Joined: 31 Dec 2009 Posts: 580 Location: London
|
|
|
|
LISTCAT gives most of those fields but only for VSAM format datasets.
For QSAM files things like keys do not apply as they're sequential access only.
Suggest you look at the IBM 'Using Data Sets' manual that covers most if not all this material. And the IBM 'VSAM Demystified' for extra detail regarding VSAM files. |
|
Back to top |
|
|
satish.ms10
Active User
Joined: 10 Aug 2009 Posts: 184 Location: India
|
|
|
|
Thank you all.
For your kind support. I will look into the 'Using Data Sets' manual. |
|
Back to top |
|
|
|