0 Replies Latest reply: Aug 28, 2012 10:25 AM by Hardik Gandhi RSS

    Section Access

    Hardik Gandhi

      Hi,

       

      here is my Section access script:

       

      star is * ;

       

      Section Access;

      SATABLE:

      LOAD upper(ACCESS) as ACCESS,

           upper(NTNAME) as NTNAME,

           upper(SAUSER) as SAUSER

       

      From xyz;

       

      Section Application;

       

      Document_Security:

      LOAD

                upper(SAUSER) as SAUSER,

                FIELDACCESS.PROGRAM,  (I want to filter the SAUSER for multiple program and not just one)

                TABACCESS.PCA,

                TABACCESS.PDD

      From ABC;

       

      Instead of creating multiple rows of record for a particular SAUSER to filter on Programs ( eg: Program Names: SAP, ADP, USC etc) how can I accomodate all the constraints/filter for program in one row of record for that SAUSER?

       

      Thanks,

      H