|
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: 3051
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 |
|
|
|
|
