Chapter 8: Reports

This chapter describes how to:

· Display, print and purge the information in the ALC log.

· Display and print information about when menu options were last used.

· Display and print detailed information about ALC menus and menu options.

· Create an output file containing information about ALC menus and menu options.

· Display and print a list of menus and menu options that a given user is authorized to access.

Displaying the ALC Log

The Display ALC Log (DSPALCLOG) command is used to display or print the information stored in the ALC log. An entry is written to the ALC log, for selected menus, each time a menu option is run.

See Creating Menus for information about setting the logging status for a menu.

You can access the DSPALCLOG command by either of the following methods:

· Select option 31 from the ALC menu.

· Prompt the DSPALCLOG command at any command line.

The prompted version of the DSPALCLOG command is shown below.

The parameters for the DSPALCLOG command are described below in the order that they appear on the command prompt. Default values are underlined.

Starting Date

Indicate the first entry date to include.

The possible values are:

*CURRENT	Entries from the current date are included.
*FIRST	All entries from the earliest available date are included.
date	Enter a date in your system date format. Entries created on or after the date specified are included.

Ending Date

Indicate the last entry date to include.

The possible values are:

*CURRENT	Entries created on or before the current date are included.
date	Enter a date in your system date format. Entries created on or before the date specified are included.

Starting Time

Indicate which entry times to include.

The possible values are:

*FIRST	All entries from the earliest available time are included.
time	Enter a time in hours:minutes:seconds format. Entries created on or after the time specified are included.

Ending Time

Indicate which entry times to include.

The possible values are:

*CURRENT	Entries created on or before the current time are included.
time	Enter a time in hours:minutes:seconds format. Entries created on or before the time specified are included.

*ALL	All entries are included, regardless of menu name.
menu-name	Enter a generic specification for the menu names to be included in the list. An asterisk (*) in the generic specification will match any string of zero or more characters in the name. An underscore (_) in the generic specification will match any single character in the name.

Option Number

Select entries by option number.

The possible values are:

*ALL	All entries are included, regardless of option number.
*START	Only the menu startup option is included.
*END	Only the menu ending option is included.
User-defined function key	Only the option associated with a user-defined function key is included. The valid user-defined function keys are F2, F6, F7, F8, F11 and F13 through *F21.
number	Enter an option number from 1 to 999.

User

Select entries by user name.

The possible values are:

*ALL	All entries are included, regardless of user name.
user-name	Enter a generic specification for the user names to be included in the list. An asterisk (*) in the generic specification will match any string of zero or more characters in the name. An underscore (_) in the generic specification will match any single character in the name.

Sort By

Indicate how to sort the list.

The possible values are:

*MENU_DATE	The list is sorted by library, menu name, date and time.
*MENU_USER	The list is sorted by library, menu name, option number, user name, date and time.
*USER_MENU	The list is sorted by user name, library, menu name, option number, date and time.
*USER_DATE	The list is sorted by user name, date and time.

Output

Specify whether to display or print the information.

The possible values are:

*	The information is shown on the display.
*PRINT	The information is printed.

A sample of the display generated by the DSPALCLOG command is shown below.

Displaying "Last Used" Information

The Display Last Used Info (DSPALCLAST) command allows you to display or print a report of menu options that were last used before or after a certain date.

Last used information is only tracked for menu options contained on menus whose log option is set to *YES. See Creating Menus for information about setting the logging option for a menu.

You can access the DSPALCLAST command by either of the following methods:

· Select option 35 from the ALC menu.

· Prompt the DSPALCLAST command at any command line.

The prompted version of the DSPALCLAST command is shown below.

The parameters for the DSPALCLAST command are described below in the order that they appear on the command prompt.

*USRLIBL	Menus in any library in the user portion of the library list are included.
*LIBL	Menus in any library in the job library list are included.
*CURLIB	Menus in the current library are included.
*ALLUSR	Menus in all user libraries are included.
*ALL	Menus in all libraries are included.
library-name	The name of the library containing the menu or menus to check.

Reference Date

Specify a date to use as a reference point for deciding which entries to display.

The possible values are:

*MONTH1	One month before the current date is used.
*MONTH2	Two months before the current date is used.
*YEAR	One year before the current date is used.
date	Enter a valid date in your system date format.

Last Used Before/After Date

Indicate whether to include menu options that were last used before or after the specified date.

The possible values are:

*BEFORE	Options last used on or before the specified date are included.
*AFTER	Options used on or after the specified date are included.

Sort By

Specify how to sort the selected entries.

The possible values are:

*MENU_DATE	Entries are sorted by menu, then last used date.
*MENU_OPT	Entries are sorted by menu, then menu option number.

Output

Specify whether to display or print the information.

The possible values are:

*	The information is shown on the display.
*PRINT	The information is printed.

A sample of the output generated by the DSPALCLAST command is shown below.

Displaying Menu Attributes

The Display ALC Menu Attributes (DSPALCMNUA) command is used to display or print the attributes of one or more ALC menus. Menu-level and option-level attributes are included.

You can also direct the output of this command to an output file for interfacing with Query and other utilities.

You can access the DSPALCMNUA command by either of the following methods:

· Select option 33 from the ALC menu.

· Prompt the DSPALCMNUA command at any command line.

The prompted version of the DSPALCMNUA command is shown below.

The parameters for the DSPALCMNUA command are described below in the order that they appear on the command prompt. Default values are underlined.

*USRLIBL	Menus in any library in the user portion of the library list are included.
*LIBL	Menus in any library in the job library list are included.
*CURLIB	Menus in the current library are included.
*ALLUSR	Menus in all user libraries are included.
*ALL	Menus in all libraries are included.
library-name	The name of the library containing the menu or menus to display.

Output

Specify the type of output desired.

The possible values are:

*	The information is shown on the display.
*PRINT	The information is printed.
*OUTFILE	The information is written to an output file. This option is useful for interfacing to other utilities and for running your own queries. The format of the output file is described by file ALPF005 in library ALC.

File to Receive Output

Enter the name of the output file to use. If the file does not exist, it will be created.

This is a required parameter if *OUTFILE is specified for the “Output” parameter.

The possible values are:

file-name

Enter a valid system name for the output file.

The possible library values are:

*LIBL	The file is located using the job library list. If the file does not exist, it is created in *CURLIB.
*CURLIB	The file is found in the jobs current library.
library-name	The name of the library containing the output file.

Output Member Options

Specify options for the output file member.

The possible member values are:

*FIRST	The first member in the specified output file is used.
member-name	Enter the member name to use. If the member does not exist, it will be added to the file.

The possible replace values are:

*REPLACE	Data in an existing member is replaced.
*ADD	New data is added to an existing member.

A sample of the display generated by the DSPALCMNUA command is shown below.

Menu Attributes Display. Part 1.

Menu Attributes Display. Part 2.

Menu Attributes Display. Part 3.

Menu Attributes Display. Part 4.

Displaying User Authorities

The Display User Authority (DSPALCAUT) command is used to display or print a list of menus and menu options that a given user is authorized to access. Non-ALC menus can be included in the list.

You can access the DSPALCAUT command by either of the following methods:

· Select option 34 from the ALC menu.

· Prompt the DSPALCAUT command at any command line.

The prompted version of the DSPALCAUT command is shown below.

The parameters for the DSPALCAUT command are described below in the order that they appear on the command prompt. Default values are underlined.

*USRLIBL	Menus in any library in the user portion of the library list are included.
*LIBL	Menus in any library in the job library list are included.
*CURLIB	Menus in the current library are included.
*ALLUSR	Menus in all user libraries are included.
*ALL	Menus in all libraries are included.
library-name	The name of the library containing the menu or menus to display.

User

Enter the name of the user profile whose authority you want to check.

The possible values are:

*CURRENT	Authority is checked for the user running this command.
user-profile	Enter a valid user profile name.

Include Non-ALC Menus

Specify whether to include non-ALC menus in the list.

The possible values are:

*NO	Only ALC menus are included.
*YES	Only ALC menus are included.

Note:

Only menu-level information can be reported for non-ALC menus. Option-level information is not available.

Output

Specify whether to display or print the information.

The possible values are:

*	The information is shown on the display.
*PRINT	The information is printed.

A sample of the display generated by the DSPALCAUT command is shown below.

Purging the ALC Log

The Purge ALC Log (PRGALCLOG) command is used to delete selected entries from the log.

You can access the PRGALCLOG command by either of the following methods:

· Select option 32 from the ALC menu.

· Prompt the PRGALCLOG command at any command line.

The prompted version of the PRGALCLOG command is shown below.

The parameters for the PRGALCLOG command are described below in the order that they appear on the command prompt. Default values are underlined.

Starting Date

Indicate the first entry date to include. This is a required parameter.

The possible values are:

*FIRST	All entries from the earliest available date are deleted.
*CURRENT	Entries from the current date are deleted.
date	Enter a date in your system date format. Entries created on or after the date specified are deleted.

Ending Date

Indicate the last entry date to include.

The possible values are:

*LASTMONTH	Entries a month or more old are deleted.
*CURRENT	Entries created on or before the current date are deleted.
date	Enter a date in your system date format. Entries created on or before the date specified are deleted.

Starting Time

Indicate which entry times to include.

The possible values are:

*FIRST	All entries from the earliest available time are deleted.
time	Enter a time in hours:minutes:seconds format. Entries created on or after the time specified are deleted.

Ending Time

Indicate which entry times to include.

The possible values are:

*CURRENT	Entries created on or before the current time are deleted.
time	Enter a time in hours:minutes:seconds format. Entries created on or before the time specified are deleted.

*ALL	All entries are deleted, regardless of menu name.
menu-name	Enter a generic specification for the menu name. An asterisk (*) in the generic specification will match any string of zero or more characters in the name. An underscore (_) in the generic specification will match any single character in the name.

User

Select entries by user name.

The possible values are:

*ALL	All entries are deleted, regardless of user name.
user-name	Enter a generic specification for the user name. An asterisk (*) in the generic specification will match any string of zero or more characters in the name. An underscore (_) in the generic specification will match any single character in the name.

Job Description

Specify the name of a job description to use to submit the request to batch.

The possible values are:

*USRPRF	The request is submitted to batch using the job description from your user profile.
*NONE	The request is not submitted to batch. The request is run immediately.
job-description	Enter the name of an existing job description to use to submit the request to batch.

The possible library values are:

*LIBL	The library list is used to locate the job description.
*CURLIB	The job description is found in the current library.
library-name	Enter the name of the library containing the specified job description.

*ALL	All menus in the specified libraries are included.
generic-name	Enter a menu name, or a generic name ending in an asterisk (*).

*ALL	All menus in the specified libraries are included.
generic-name	Enter a menu name, or a generic name ending in an asterisk (*).

*ALL	All menus in the specified libraries are included.
generic-name	Enter a menu name, or a generic name ending in an asterisk (*).