Hi Madhukar,

It is not entirely clear to me what you are referring to exactly.

LIKELIST copies a SELECT clause, but that requires the report to be of the same type, and I am guessing the earlier report is not a REPORT_SCOPE one.

SCOPE= expects an ID, not a clause.

So you might be looking to generate SCOPE=id1 SCOPE=id2 etc.

Regards,

Hi Jeroen,

sorry for the confusion.

My code: it generates the report of inactive users: 

N TYPE=RACF NAME=XYZ DD=CKR2PASS 

S S=BASE C=USER PASSINT_EFFECTIVE<>255 LJDATE<TODAY-90 

SORTLIST KEY

N TYPE=RACF NAME=ABC1 DD=CKR2PASS 

SELECT LIKLIST=XYZ 

SORTLIST CLASS KEY 

REPORT SCOPE=XYZ 

Instead of manually providing the list of users in SCOPE, whether I can code with complete list of users? 

Regards

Madhukar

Hi Madhukar,

It is not entirely clear to me what you are referring to exactly.

LIKELIST copies a SELECT clause, but that requires the report to be of the same type, and I am guessing the earlier report is not a REPORT_SCOPE one.

SCOPE= expects an ID, not a clause.

So you might be looking to generate SCOPE=id1 SCOPE=id2 etc.

Regards,

Hi Madhukar,

You have three queries there, two of TYPE=RACF and a scope report. 

Since you did not specify a REPORT_SCOPE layout yourself, I take it SCKRCARL(CKRRSCOP) will be embedded there.
(You should be able to see that in SYSPRINT.)

Assuming you don't have an ID XYZ in your database, I take it the REPORT SCOPE=XYZ cannot produce any output.

===

If you are looking to run a scope report in a second pass, I think you are looking for something more like this:

N TYPE=SYSTEM OUTLIM=1 DD=CKR2PASS
SORTLIST "REPORT ,"

N TYPE=RACF NAME=XYZ DD=CKR2PASS 

S S=BASE C=USER PASSINT_EFFECTIVE<>255 LJDATE<TODAY-90 

SORTLIST "SCOPE="| KEY(0) ","

N TYPE=SYSTEM OUTLIM=1 DD=CKR2PASS
SORTLIST "SCOPE=XYZ"     /* need to put something to close command... */

Since this does not specify a REPORT_SCOPE layout, the CKRRSCOP default one will be used.
If you want to define your own N TYPE=REPORT_SCOPE layout, you need to include that in the input before the REPORT statement.

I hope this begins to help.

Regards,

Hi Jeroen,

sorry for the confusion.

My code: it generates the report of inactive users: 

N TYPE=RACF NAME=XYZ DD=CKR2PASS 

S S=BASE C=USER PASSINT_EFFECTIVE<>255 LJDATE<TODAY-90 

SORTLIST KEY

N TYPE=RACF NAME=ABC1 DD=CKR2PASS 

SELECT LIKLIST=XYZ 

SORTLIST CLASS KEY 

REPORT SCOPE=XYZ 

Instead of manually providing the list of users in SCOPE, whether I can code with complete list of users? 

Regards

Madhukar

Hi Madhukar,

It is not entirely clear to me what you are referring to exactly.

LIKELIST copies a SELECT clause, but that requires the report to be of the same type, and I am guessing the earlier report is not a REPORT_SCOPE one.

SCOPE= expects an ID, not a clause.

So you might be looking to generate SCOPE=id1 SCOPE=id2 etc.

Regards,

Hi Madhukar,

You have three queries there, two of TYPE=RACF and a scope report. 

Since you did not specify a REPORT_SCOPE layout yourself, I take it SCKRCARL(CKRRSCOP) will be embedded there.
(You should be able to see that in SYSPRINT.)

Assuming you don't have an ID XYZ in your database, I take it the REPORT SCOPE=XYZ cannot produce any output.

===

If you are looking to run a scope report in a second pass, I think you are looking for something more like this:

N TYPE=SYSTEM OUTLIM=1 DD=CKR2PASS
SORTLIST "REPORT ,"

N TYPE=RACF NAME=XYZ DD=CKR2PASS 

S S=BASE C=USER PASSINT_EFFECTIVE<>255 LJDATE<TODAY-90 

SORTLIST "SCOPE="| KEY(0) ","

N TYPE=SYSTEM OUTLIM=1 DD=CKR2PASS
SORTLIST "SCOPE=XYZ"     /* need to put something to close command... */

Since this does not specify a REPORT_SCOPE layout, the CKRRSCOP default one will be used.
If you want to define your own N TYPE=REPORT_SCOPE layout, you need to include that in the input before the REPORT statement.

I hope this begins to help.

Regards,

Hi Jeroen,

sorry for the confusion.

My code: it generates the report of inactive users: 

N TYPE=RACF NAME=XYZ DD=CKR2PASS 

S S=BASE C=USER PASSINT_EFFECTIVE<>255 LJDATE<TODAY-90 

SORTLIST KEY

N TYPE=RACF NAME=ABC1 DD=CKR2PASS 

SELECT LIKLIST=XYZ 

SORTLIST CLASS KEY 

REPORT SCOPE=XYZ 

Instead of manually providing the list of users in SCOPE, whether I can code with complete list of users? 

Regards

Madhukar

Hi Madhukar,

It is not entirely clear to me what you are referring to exactly.

LIKELIST copies a SELECT clause, but that requires the report to be of the same type, and I am guessing the earlier report is not a REPORT_SCOPE one.

SCOPE= expects an ID, not a clause.

So you might be looking to generate SCOPE=id1 SCOPE=id2 etc.

Regards,