Need to check whether file is ESDS file or not by using REXX

IBM's Command List programming language & Restructured Extended Executor
Devrana
Posts: 15
Joined: Tue May 17, 2022 12:57 pm
Skillset: Mainframe Developer
Referer: Through Colleague

Need to check whether file is ESDS file or not by using REXX

Postby Devrana » Sat Oct 05, 2024 2:28 pm

Hello Team,

I have list of files and I would like to know which file is ESDS among those files using REXX. I thought of using LISTCAT but not sure how to use it in REXX. Please assist.

User avatar
sergeyken
Posts: 458
Joined: Wed Jul 24, 2019 10:12 pm
Skillset: Assembler, JCL, Utilities, PL/I, C/C++, DB2, SQL, REXX, COBOL, etc. etc. etc.
Referer: Internet search

Re: Need to check whether file is ESDS file or not by using

Postby sergeyken » Sat Oct 05, 2024 7:51 pm

Code: Select all

x = OUTTRAP( 'LISTING.' )       /* reroute output to REXX stem */
"TSO LISTDS ...parameters...."  /* execute TSO command */
y = OUTTRAP( 'OFF' )            /* stop rerouting */

/* analyze LISTDS output line-by-line */
Do I = 1 To LISTING.0
   Say LISTING.I
End I
Javas and Pythons come and go, but JCL and SORT stay forever.

Devrana
Posts: 15
Joined: Tue May 17, 2022 12:57 pm
Skillset: Mainframe Developer
Referer: Through Colleague

Re: Need to check whether file is ESDS file or not by using

Postby Devrana » Sat Oct 05, 2024 10:56 pm

Thanks for your response!

Can I check with 'Non indexed' on any of the listing paramater ? If yes then could you please assist me on that.

willy jensen
Posts: 474
Joined: Thu Mar 10, 2016 5:03 pm
Skillset: assembler rexx zOS ispf racf smf
Referer: saw it in the experts foprum thought I could help here

Re: Need to check whether file is ESDS file or not by using

Postby willy jensen » Sun Oct 06, 2024 1:41 pm

The word LINEAR springs to mind. Or perhaps better look for INDEXED not in the list. They will be in the ATTRIBUTES subsection of the DATA section.

User avatar
sergeyken
Posts: 458
Joined: Wed Jul 24, 2019 10:12 pm
Skillset: Assembler, JCL, Utilities, PL/I, C/C++, DB2, SQL, REXX, COBOL, etc. etc. etc.
Referer: Internet search

Re: Need to check whether file is ESDS file or not by using

Postby sergeyken » Mon Oct 07, 2024 11:29 pm

Devrana wrote:Thanks for your response!

Can I check with 'Non indexed' on any of the listing paramater ? If yes then could you please assist me on that.

Use

Code: Select all

"TSO LISTCAT ENTRIES('TEST.ABC.DEF.GHI')"


For VSAM, you should get something like this:

Code: Select all

CLUSTER ------- TEST.ABC.DEF.GHI            
     IN-CAT --- CATALOG.USER.SUB2.TEST                  
   DATA ------- TEST.ABC.DEF.GHI.DATA      
     IN-CAT --- CATALOG.USER.SUB2.TEST                  
   INDEX ------ TEST.ABC.DEF.GHI.INDEX      
     IN-CAT --- CATALOG.USER.SUB2.TEST                  


Keyword for VSAM in this output is: CLUSTER (and also DATA, INDEX in following lines).
If not-VSAM, you'll get NON-VSAM.
Javas and Pythons come and go, but JCL and SORT stay forever.

willy jensen
Posts: 474
Joined: Thu Mar 10, 2016 5:03 pm
Skillset: assembler rexx zOS ispf racf smf
Referer: saw it in the experts foprum thought I could help here

Re: Need to check whether file is ESDS file or not by using

Postby willy jensen » Tue Oct 08, 2024 12:28 am

Should have mentioned that those sections are only shown if you do a LISTCAT ENT('name') ALL.
Or like in Segeykens sample, if the 'INDEX --' is missing then it is not indexed.

User avatar
sergeyken
Posts: 458
Joined: Wed Jul 24, 2019 10:12 pm
Skillset: Assembler, JCL, Utilities, PL/I, C/C++, DB2, SQL, REXX, COBOL, etc. etc. etc.
Referer: Internet search

Re: Need to check whether file is ESDS file or not by using

Postby sergeyken » Tue Oct 08, 2024 5:25 pm

You can also try

Code: Select all

"TSO LISTCAT LEVEL('hlq-prefix') CLUSTER and/or DATA and/or INDEX"


Do something yourself, do not wait for help from heaven.
Javas and Pythons come and go, but JCL and SORT stay forever.


  • Similar Topics
    Replies
    Views
    Last post