"concatenate" rows into a grid
Posted: Thu Sep 08, 2011 1:45 pm
Report: Racf-User defined in Lpar
Looking for a way to "concatenate" rows into a grid.
Input: (userid=8char, Name=20char, Lpar=4char)
Result:
Managed to create the 'Y"s but on separate rows...
...with these parms:
.
.
Would even be nice with a header like
Can somebody help me with this?
//Lasse
Looking for a way to "concatenate" rows into a grid.
Input: (userid=8char, Name=20char, Lpar=4char)
USERID1 NAME-OF-USER PROD
USERID1 NAME-OF-USER ACPT
USERID1 NAME-OF-USER TEST
USERID2 NAME-OF-USER PROD
USERID3 NAME-OF-USER ACPT
USERID1 NAME-OF-USER ACPT
USERID1 NAME-OF-USER TEST
USERID2 NAME-OF-USER PROD
USERID3 NAME-OF-USER ACPT
Result:
User Name Prod Acpt Test
USERID1 NAME-OF-USER Y Y Y
USERID2 NAME-OF-USER Y
USERID3 NAME-OF-USER Y
USERID1 NAME-OF-USER Y Y Y
USERID2 NAME-OF-USER Y
USERID3 NAME-OF-USER Y
Managed to create the 'Y"s but on separate rows...
USERID1 NAME-OF-USER Y
USERID2 NAME-OF-USER Y
USERID2 NAME-OF-USER Y
USERID2 NAME-OF-USER Y
USERID2 NAME-OF-USER Y
USERID2 NAME-OF-USER Y
USERID2 NAME-OF-USER Y
USERID2 NAME-OF-USER Y
USERID2 NAME-OF-USER Y
...with these parms:
OUTREC IFTHEN=(WHEN=(LPAR,EQ,C'PROD'),
BUILD=(01,30,36:C'Y')),
IFTHEN=(WHEN=(LPAR,EQ,C'ACPT'),
BUILD=(01,30,39:C'Y')),
BUILD=(01,30,36:C'Y')),
IFTHEN=(WHEN=(LPAR,EQ,C'ACPT'),
BUILD=(01,30,39:C'Y')),
.
.
Would even be nice with a header like
User Name P A T
xxxx xxxxx Y Y
xxxx xxxxx Y Y
Can somebody help me with this?
//Lasse