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
 

 

Reg System Commands to Get File Properties in Mainframe

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
satish.ms10

Active User


Joined: 10 Aug 2009
Posts: 158
Location: India

PostPosted: Tue Sep 02, 2014 3:01 pm    Post subject: Reg System Commands to Get File Properties in Mainframe
Reply with quote

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
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Thu Sep 25, 2014 11:25 pm    Post subject:
Reply with quote

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
View user's profile Send private message
steve-myers

Active User


Joined: 30 Nov 2013
Posts: 461
Location: The Universe

PostPosted: Fri Sep 26, 2014 3:20 am    Post subject:
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Fri Sep 26, 2014 4:04 am    Post subject:
Reply with quote

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
View user's profile Send private message
Pete Wilson

Active User


Joined: 31 Dec 2009
Posts: 437
Location: London

PostPosted: Thu Nov 20, 2014 1:19 am    Post subject:
Reply with quote

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
View user's profile Send private message
satish.ms10

Active User


Joined: 10 Aug 2009
Posts: 158
Location: India

PostPosted: Mon Nov 24, 2014 12:37 pm    Post subject:
Reply with quote

Thank you all.

For your kind support. I will look into the 'Using Data Sets' manual.
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 -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm


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