Re: DFSORT - compare two fields

2021-07-30 Thread Radoslaw Skorupka
Yes, it works as desired. Thank you! -- Radoslaw Skorupka Lodz, Poland W dniu 30.07.2021 o 14:31, S.Karthik Premnath pisze: HTH //RSPROF EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //IRRDBU00 DD DISP=SHR,DSN= //OUTPUT DD SYSOUT=* //TOOLIN DD * SELECT FROM(IRRDBU00)

Re: DFSORT - compare two fields

2021-07-30 Thread S.Karthik Premnath
HTH //RSPROF EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //IRRDBU00 DD DISP=SHR,DSN= //OUTPUT DD SYSOUT=* //TOOLIN DD * SELECT FROM(IRRDBU00) TO(OUTPUT) USING(CTL1) /* //CTL1CNTL DD * INCLUDE COND=(50,8,CH,NE,60,8,CH) /* Assuming 50,8 & 60,8 are offset and length of userid &

DFSORT - compare two fields

2021-07-30 Thread Radoslaw Skorupka
The following scenario: IRRDBU00 file, record type 0203 - this is about user to group connection. There are fields: groupname and owner. Usually the owner is also the group. I want to list all the record where owner is not groupname. So the goal is to compare two (fixed) fields and include/omit