Creating filelist ps file

chamajid · Posted: Thu Aug 12, 2021 6:01 am

HI

I need some help in jcl where we have a 100's of datasets and we receive one every week. We need to load the last 30 ps dataset names into another ps dataset. Our etl program uses a filelist to read the names of the datasets and load those 30 datasets into the database.

Dataset names

PDABC.BJHGY.F123.T001
PDABC.BJHGY.F123.T002
PDABC.BJHGY.F123.T003
PDABC.BJHGY.F123.T004
PDABC.BJHGY.F123.T005
PDABC.BJHGY.F123.T006
.....
PDABC.BJHGY.F123.T100

Put names Into this PS
BJHGV.ABCD.F123.FILELIST

Thanks,
Chamajid

Willy Jensen · Posted: Thu Aug 12, 2021 2:05 pm

You cannot do it just in JCL.
The solution depends on whether you are ok with entering the datasetnames yourself, in which case you can use ISPF 3.4 to list the datasetnames and cut/paste to the list dataset. Or save the entire list and edit the generated dataset.
Otherwise you need a program. REXX springs to mind as you can easily do a LISTCAT to get the names and generate the list.

Rohit Umarjikar · Posted: Thu Aug 12, 2021 4:09 pm

ibmmainframes.com/about42452.html
I would try with LISTCAT then use DFSORT to include just the name.
ibmmainframes.com/about34669.html