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: 1717
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: 525
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: 8086
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: 440
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 FTP xls file from Mainfrmae kumarsatheeshc1 TSO/ISPF 5 Tue Jun 20, 2017 6:56 pm
No new posts Validate if a Value from the file is ... balacsv2 COBOL Programming 8 Mon Jun 19, 2017 11:52 pm
No new posts Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am
No new posts Dynamic output file creation in cobol... smileheal COBOL Programming 7 Thu Jun 15, 2017 10:53 pm
No new posts compare 2 rows within the same file ram_vizag SYNCSORT 7 Wed Jun 14, 2017 12:34 am


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