Hello. I need to produce a report that shows IDs that have access to APF datasets. I have it working for the most part, but I'd like the DSN to print on each row. With my query below, the DSN only prints on the first row then blank from there on until the next dataset. I appreciate any suggestions. My query is:

newlist type=sensdsn nopage

select apf=yes or apflist=yes

sortlist racf_acl(universal,effective) dsn

Hello Mark,

You can add RETAIN to your newlist to achieve this.

All fields that are not part of a repeat group are blank in subsequent lines unless the RETAIN parameter was specified on the OPTION or NEWLIST command.

Regards, Mike

Thank you, Mike!