Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 160
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: 1806
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 Member


Joined: 30 Nov 2013
Posts: 574
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: 8165
Location: East Dubuque, Illinois, USA

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: 445
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: 160
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 Identifying Interfaces in CICS/mainframe Ashishpanpaliya CICS 5 Fri Oct 13, 2017 3:21 pm
This topic is locked: you cannot edit posts or make replies. Rexx to execute spool commands upendrasri CLIST & REXX 5 Wed Oct 04, 2017 6:54 am
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
This topic is locked: you cannot edit posts or make replies. Rexx to execute spool commands upendrasri CLIST & REXX 47 Fri Sep 29, 2017 1:08 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us