Re: SORT INCLUDE problem

2023-09-20 Thread Jack Zukt
Hello Kolusu, Thank you very much for your help. I was not quite happy with the solution that I had come up with, as I was reading the input file twice and that bothered me because that is not an efficient solution. You latest solution is much simpler and efficient. And much more elegant as well.

Re: SORT INCLUDE problem

2023-09-18 Thread Sri h Kolusu
>> Is there a way to get all the dataset profiles that have two different >> groups with the same access using SORT or ICETOOL but without using >> JOINKEYS, so that the input file would only needed to be read once, using >> SORTIN as the DDNAME? Jack, That is quite simple. There is a lot of

Re: SORT INCLUDE problem

2023-09-18 Thread Jack Zukt
Hi Kolusu I tried the JCL that you have sent. It works, as expected, but maybe I was not quite clear in my last question. Is there a way to get all the dataset profiles that have two different groups with the same access using SORT or ICETOOL but without using JOINKEYS, so that the input file

Re: SORT INCLUDE problem

2023-09-15 Thread Sri h Kolusu
>> Now, my question is, is there a way to do this with only one step and >> reading the input file only once? Jack, Here is 1 step JCL that would match the STG with CICS records the type 0404 records from the input file. Note that we can additional functionality if you need after the match

Re: SORT INCLUDE problem

2023-09-15 Thread Jack Zukt
Hi Kolusu, Thank you very much for your input. The input file already is a subset of 0404 records, and the SUM FIELDS=NONE was the culprit. Once again the trouble come from copying a previously used JCL and not cleaning it properly. Now, if you will not mind, I have another question regarding

Re: SORT INCLUDE problem

2023-09-15 Thread Sri h Kolusu
>>> I am using for the INPUT a subset of a type 0404 records from a IRRDBU00 >>> output file. In the first step I am crating two files with Jack, Not clear if you still need help , but the INCLUDE COND does not have the include for type 0404 records, unless you already filtered your input.

Re: SORT INCLUDE problem

2023-09-15 Thread Jack Zukt
Ok, I found the problem (I think) It was probably due to the "SUM FIELDS=NONE" statement Best wishes Jack On Fri, 15 Sept 2023 at 10:42, Jack Zukt wrote: > Hi, > > I am trying to find a RACF dataset profile for which two different groups > have ALTER access. > I am using for the INPUT a subset

SORT INCLUDE problem

2023-09-15 Thread Jack Zukt
Hi, I am trying to find a RACF dataset profile for which two different groups have ALTER access. I am using for the INPUT a subset of a type 0404 records from a IRRDBU00 output file. In the first step I am crating two files with the dataset profiles in which the groups have ALTER authority:

Re: Sort INCLUDE problem

2023-04-28 Thread Sri h Kolusu
>> You job is not summarizing by HLQ; instead is creating one record by each >> input record with HLQ and size. Jack, Now that I know what you are trying to do, it is quite easy to add the summary by HLQ in the same step. You have 2 different multiplications so we need to use IFTHEN

Re: Sort INCLUDE problem

2023-04-28 Thread Jack Zukt
Hello Kolusu, I think that this DFSORT statements should work: SKIP,1 BRS-BYT,*,16,PD LX-BYT,*,16,PD //SYSINDD *,SYMBOLS=EXECSYS INREC PARSE=(%01=(ABSPOS=2,ENDBEFR=C'.',FIXLEN=8)), OVERLAY=(BRS-HLQ:%01, BRS-BYT:INP-FLSIZE,TO=PD,LENGTH=16,

Re: Sort INCLUDE problem

2023-04-28 Thread Jack Zukt
Hello Kolusu, Thank you for your quick answer. As you have guessed, my problem is on the two first steps, which you have consolidated in one. The management class is only relevant for spiting the information into two files; what I need is to summarize the size by high level qualifier for the

Re: Sort INCLUDE problem

2023-04-28 Thread Sri h Kolusu
>> What is troubling me is that I have at least one HLQ that is present on both >> files with the records separated by the management class, but that HLQ is >> only present on the summarized by HLQ file that does not have that specific >> management class. And the INCLUDE that I am using is

Sort INCLUDE problem

2023-04-28 Thread Jack Zukt
Hi I have this file in which each record has a tape dataset name, the creation date, the last ref date, size and management class. I need to summarize the size by high level qualifier and to create a file with all the record that have one specific management class, and do the same for the records