IBM Security Z Security

Security for Z

Join this online user group to communicate across Z Security product users and IBM experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  Repeating Fields Each Line

    Posted Wed February 08, 2023 10:29 AM
    I have a user attribute and group report with an existing layout (in-part) of:
    LOCATION USERID RACFGROUP (more columns follow)
    first              user01   group1
                                      group2
                                      group3
                                      group4

    The request I can't solve wants the layout as:
    LOCATION USERID RACFGROUP
    first              user01   group1
    first              user01   group2
    first              user01   group3
    first              user01   group4

    Query:
    DefType type=$BID
    Alloc type=$BID dd=BIDS
    Suppress msg=2363
    Define type=$bid id(8,char,'Id') as Substr(record,1,8)
    Define type=$bid bid(3,char,'BID') as Substr(record,10,3)

    Newlist type=racf dd=IZP0RF02
    Define DCS boolean where owner:anysupgroup=(NOB,STS)

    Select class=user segment=base DCS
    Exclude cggrpct=0

    Sortlist,
    'DATE'(toptitle),
    :run.Datetime(toptitle),
    ' REPORT-02'(toptitle,24),
    'DCS - USERID ATTRIBUTE AND GROUP INFORMATION'(toptitle),

    dcs(3,str$blank('DCS'),'BID'),

    key(8,'Userid'),
    Complex(5,'RACF'),
    Dfltgrp,
    Name,
    Revoke(1,hb,'R'),
    Special(1,hb,'S'),
    Operations(1,hb,'O'),
    Auditor(1,hb,'A'),
    Uaudit(1,hb,'U'),
    ljdate(usdate,8,'Last Use'),
    connects(nd),
    connects:$bid.id.bid(6,'GrpBID'),
    connects(22,'Group Auth r soa'),
    connects:cgdefdat(usdate,8,'ConnDate')

    ------------------------------
    Jack Yucuis
    ------------------------------


  • 2.  RE: Repeating Fields Each Line

    Posted Wed February 08, 2023 11:07 AM
    Hi Jack,

    You can repeat non-repeating fields for each line of output [on the record level--in this case for the SORTLIST] using the RETAIN modifier.

    If you want this for all of them, you can specify the modifier on the NEWLIST statement.
    The modifier can also be specified on the individual field.

    Note: This will not let you repeat the value of a repeating field that happens to have only one  value in the record.

    Regards,

    ------------------------------
    Jeroen Tiggelman
    Software Development and Level 3 Support Manager IBM Security zSecure Suite
    IBM
    Delft
    ------------------------------

    Original Message


  • 3.  RE: Repeating Fields Each Line

    Posted Thu February 09, 2023 01:37 PM

    Thank you very much Jereon - works perfectly.



    ------------------------------
    Jack Yucuis
    ------------------------------

    Original Message


Related Content