MVSFORUMS.com

gharidoss

Hi All,

I have around 1000 files, I want to know the records count of the each files. currently, I'm using te SORT FIELDS = COPY option and SORTOUT is DUMMY for all the files. In the SDSF, I see the number of records in and number of records out. But I want to display the input filename in SYSOUT, so that I can identify it's belongs to which file. Is there any option to display the input file name in SDSF (SYSOUT)

Any ideas would be greatly appreciated. Thank you.

Phantom · Posted: Wed Nov 09, 2005 2:37 am Post subject:

GHaridoss,
Are you concatenating all files to SORTIN of 1 step (You cannot have so many concatenations anyway) or do you have 1000 steps each running a dummy sort job ?

Your requirement is a bit tricky and this is not possible with SORT alone. You may need to use a high level language like COBOL / REXX to accomplish this - along with SORT.

Follow these steps:
Step 1. Code a SORT step with as much datasets concanated to sortin (all concatenated datasets must of same LRECL to get desired result). Route the Sysout to a dataset.

Step 2. invoke the rexx routine provided in the link below (provided by Kolusu). You need to play around with Control blocks to find the dataset name associated with a ddname. I suggest you first try the REXX routine - alone - couple of times to understand how it works.

http://mvsforums.com/helpboards/viewtopic.php?t=2608&highlight=jfcb

Thanks,
Phantom

gharidoss · Posted: Wed Nov 09, 2005 3:13 am Post subject:

Hi Phantom,

I'm not able to do concatenation, because all the files are different record format and different record length varying form 30 - 4500 bytes.

I need this requirement for reporting purpose. currently I created 1000 sort steps to acheive this requirement.

Any ideas or suggestion would be greatly appreciated.

Thanks,
Haridoss

kolusu · Posted: Wed Nov 09, 2005 9:07 am Post subject:

Deleted all wild goose chase posts in this topic by Admin.

Guys please slow down and try to answer correctly !

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

kolusu · Posted: Wed Nov 09, 2005 9:18 am Post subject:

gharidoss,

Check this topic which discusses a similar issue. The only change required would be the control cards as you have datasets with lrecl ranging from 35 to 4500 bytes

http://mvsforums.com/helpboards/viewtopic.php?p=10745#10745

Frank Yaeger · Posted: Wed Nov 09, 2005 11:30 am Post subject:

gharidoss · Posted: Wed Nov 09, 2005 11:22 pm Post subject:

Hi All,

Thanks for your updation. also I verified its' working fine.

Thanks
Haridoss

whizkid79 · Beginner Joined: 29 Sep 2004 Posts: 53 Topics: 14

Is there a solution to find out the counts of files of recfm = VB?

I have a VB file of length 1200.

I'm using DFSORT with the following SYSIN parms:

kolusu · Posted: Wed Mar 01, 2006 4:23 am Post subject:

whizkid79,

whizkid79,

You don't need an OUTREC FIELDS statement for counting the total no: of records. Try this

whizkid79 · Beginner Joined: 29 Sep 2004 Posts: 53 Topics: 14

It worked. Thanks Kolusu.