How to list logonids in ACF2 that have a value range for a specific field
search cancel

How to list logonids in ACF2 that have a value range for a specific field

book

Article ID: 244680

calendar_today

Updated On:

Products

ACF2 - z/OS ACF2 ACF2 - MISC

Issue/Introduction

A USER field is defined in the ACFFDR referred to as NUMBER.

How can ACF2 be used to list logonids within a range in this numeric field?

For example: between 123400000 and 123400099

Environment

Component : ACF2 for z/OS

Resolution

To list all logonids with NUMBER between 123400000 and 123400099 this command can be used:

ACF
SET TERSE
LIST IF(NUMBER >= u'123400000' and NUMBER <= u'123400099')
END

You can also use the ACFRPTSL report to list user fields.

Example:

//ACFRPTSL EXEC PGM=ACFRPTSL
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
TITLE(NUMBER field: VALUE01/VALUE02)
REPORT(SHORT)
INPUT(ACF2)
IF(NUMBER GE U'VALUE01' AND NUMBER LE 'VALUE02')
SFLDS(NUMBER)

If you are concerned about performance of these commands, you can run ACFRPTSL with INPUT(BKUP)

BKUP

Specifies input is accepted as a VB format file, as produced by the ACF2  automatic backup facility.
This parameter does not affect performance like the ACF2 parameter.