I have been asked to create report regarding USERs (starting with U*) and their assigned PROFILE (not sessions) (what user can use)
so &UIDXNAME and their &PIDXNAME on the same report..
do you have some trick how to solve that? so I would like to mix EXTRACT 'USER AND ALL SESSIONS' and 'PROFILE AND ALL SESSIONS' in reporting..
EXTRACT GIVING(EXTFILE) USER AND ALL SESSIONS (UIDXNAME(U---------))
REPORT GIVING(USERLIST) USING(EXTFILE)
(('0&UIDXNAME ' '&UENTUSER' '&UENTAPPL' '&UENTOPTI' '&PIDXNAME'))
If you really just want userids by a mask "U-", and their profiles, then take a look in your **.CB0VSRC library. Start with BRPTUPRF. I believe you could do something as simple as:
EXTRACT GIVING(EXTFILE) USER AND NO SESSIONS (UIDXNAME(U-------)
' USERID 1ST PROF 2ND PROF 3RD PROF 4TH PROF'
REPORT GIVING(RPTFILE) USING(EXTFILE)
(( '0&UIDXNAME' '&VUSR$PRF '))