Start of change

COMMAND_INFO view

Edit online

The COMMAND_INFO view returns information about all CL commands on the system.

The values returned for the result columns in the view are closely related to the values returned by the Display Command (DSPCMD) CL command and the Retrieve Command Information (QCDRCMDI) API.

Authorization: The caller must have:
  • *EXECUTE authority to the library containing the command, and
  • *USE authority to the command.

The following table describes the columns in the view. The system name is CMD_INFO. The schema is QSYS2.

Table 1. COMMAND_INFO view
Column Name System Column Name Data Type Description
COMMAND_LIBRARY CMD_LIB VARCHAR(10) The name of the library in which the command resides.
COMMAND_NAME CMD VARCHAR(10) The name of the command about which information is being returned.
PROXY_COMMAND PROXY_CMD VARCHAR(3) Whether the command is a proxy command.
NO
This command is not a proxy command.
YES
This command is a proxy command.
PROXY_TARGET_COMMAND_LIBRARY PRXTGT_LIB VARCHAR(10)
Nullable
 The name of the library in which the proxy target command resides. Can contain the special value *LIBL.

Contains the null value if PROXY_COMMAND is NO.
PROXY_TARGET_COMMAND PRXTGT_CMD VARCHAR(10)
Nullable
 The name of the proxy target command. This could be another proxy command.

Contains the null value if PROXY_COMMAND is NO.
TEXT_DESCRIPTION TEXT VARCHAR(50)
Nullable
 The text description of the command.

Contains the null value if there is no text description.
COMMAND_PROCESSING_PROGRAM_LIBRARY CPP_LIB VARCHAR(10)
Nullable
 The name of the library in which the command processing program resides. Can contain the special value *LIBL.

Contains the null value if COMMAND_PROCESSING_PROGRAM contains the special value *REXX, or if PROXY_COMMAND is YES.
COMMAND_PROCESSING_PROGRAM CPP_PGM VARCHAR(10)
Nullable
 The name of the program that accepts parameters from the command and processes the command. Can contain the following special value:
*REXX
The command is processed by REXX.
Contains the null value if PROXY_COMMAND is YES.
COMMAND_PROCESSING_PROGRAM_STATE CPP_STATE VARCHAR(7)
Nullable
 The state the command processing program is called from.
*SYSTEM
The command processing program is called from system state.
*USER
The command processing program is called from user state.

Contains the null value if PROXY_COMMAND is YES.

SOURCE_FILE_LIBRARY SRCLIB VARCHAR(10)
Nullable
 The name of the library in which the source file resides.

Contains the null value if a stream file was used to create the command, or if PROXY_COMMAND is YES.
SOURCE_FILE SRCFILE VARCHAR(10)
Nullable
 The name of the source file that contains the source file member used to create the command.

Contains the null value if a stream file was used to create the command, or if PROXY_COMMAND is YES.
SOURCE_FILE_MEMBER SRCMBR VARCHAR(10)
Nullable
 The name of the source file member that contains the command definition statements used to create the command.

Contains the null value if a stream file was used to create the command, or if PROXY_COMMAND is YES.
VALIDITY_CHECKING_PROGRAM_LIBRARY VLD_LIB VARCHAR(10)
Nullable
 The name of the library in which the validity checking program resides.

Contains the null value if VALIDITY_CHECKING_PROGRAM contains the null value, or if PROXY_COMMAND is YES.
VALIDITY_CHECKING_PROGRAM VLD_PGM VARCHAR(10)
Nullable
 The name of a program that performs additional user-defined validity checking on the parameters in the command.

Contains the null value if no validity checking program is defined, or if PROXY_COMMAND is YES.
VALIDITY_CHECKING_PROGRAM_STATE VLD_STATE VARCHAR(7)
Nullable
 The state the validity checking program is called from.
*SYSTEM
The validity checking program is called from the system state.
*USER
The validity checking program is called from the user state.

Contains the null value if VALIDITY_CHECKING_PROGRAM contains the null value, or if PROXY_COMMAND is YES.

PROMPT_TEXT_MESSAGE_FILE_LIBRARY PMT_LIB VARCHAR(10)
Nullable
 The name of the library in which the prompt message file resides. Can contain the special value *LIBL.

Contains the null value if PROMPT_TEXT_MESSAGE_FILE contains the null value, or if PROXY_COMMAND is YES.

PROMPT_TEXT_MESSAGE_FILE PMT_MSGF VARCHAR(10)
Nullable
 The name of the message file that contains the prompt text for this command.

Contains the null value if no message file was specified for prompt text, or if PROXY_COMMAND is YES.
RETRIEVE_PROMPT_MESSAGE RTVPMTMSG VARCHAR(8)
Nullable
 Whether text messages used by the command are retrieved from the prompt message file when the command is prompted.
*DYNAMIC
When the command is prompted, the prompt text will be dynamically retrieved from PROMPT_TEXT_MESSAGE_FILE.
*STATIC
When the command is prompted, the prompt text will be retrieved from the static copies of the messages stored in the *CMD object when the command was created.

Contains the null value if no message file was specified for prompt text, or if PROXY_COMMAND is YES.
PROMPT_OVERRIDE_PROGRAM_LIBRARY PMTOVR_LIB VARCHAR(10)
Nullable
 The name of the library in which the prompt override program resides.

Contains the null value if PROMPT_OVERRIDE_PROGRAM contains the null value, or if PROXY_COMMAND is YES.
PROMPT_OVERRIDE_PROGRAM PMTOVR_PGM VARCHAR(10)
Nullable
 The name of the prompt override program that replaces default values (on the prompt display) with the current actual values for the parameter.

Contains the null value if no prompt override program is specified, or if PROXY_COMMAND is YES.
PROMPT_OVERRIDE_PROGRAM_STATE PMTOVR_ST VARCHAR(7)
Nullable
 The state the prompt override program is called from.
*SYSTEM
The prompt override program is called from the system state.
*USER
The prompt override program is called from the user state.

Contains the null value if PROMPT_OVERRIDE_PROGRAM contains the null value, or if PROXY_COMMAND is YES.
MESSAGE_FILE_LIBRARY MSGF_LIB VARCHAR(10)
Nullable
 The name of the library in which the message file resides. Can contain the special value *LIBL.

Contains the null value if PROXY_COMMAND is YES.
MESSAGE_FILE MSGF VARCHAR(10)
Nullable
 The name of the message file from which messages identified on the Dependency (DEP) command definition statements are retrieved.

Contains the null value if PROXY_COMMAND is YES.
HELP_PANEL_GROUP_LIBRARY PNLGRP_LIB VARCHAR(10)
Nullable
 The name of the library in which the panel group resides. Can contain the special value *LIBL.

Contains the null value if HELP_PANEL_GROUP contains the null value, or if PROXY_COMMAND is YES.
HELP_PANEL_GROUP PNLGRP VARCHAR(10)
Nullable
 The name of the panel group in which the online help information exists for this command.

Contains the null value if no help panel group is defined for this command, or if PROXY_COMMAND is YES.
HELP_IDENTIFIER HELP_ID VARCHAR(10)
Nullable
 The root name for all help section identifiers for this command. All help sections in the help panel group associated with this command will begin with this name.

Contains the null value if no help identifier is specified, or if PROXY_COMMAND is YES.
HELP_SEARCH_INDEX_LIBRARY HELP_LIB VARCHAR(10)
Nullable
 The name of the library in which the help search index resides. Can contain the special value *LIBL.

Contains the null value if HELP_SEARCH_INDEX is null, or if PROXY_COMMAND is YES.

HELP_SEARCH_INDEX HELP_INDEX VARCHAR(10)
Nullable
 The name of the help search index for this command.

Contains the null value if no help search index is specified, or if PROXY_COMMAND is YES.
CURRENT_LIBRARY_NAME CURLIB VARCHAR(10)
Nullable
 The name of the library used as the current library during the processing of this command. Can contain the following special values:
*CRTDFT
No current library is active during processing of the command.
*NOCHG
The current library does not change for the processing of this command.

Contains the null value if PROXY_COMMAND is YES.

PRODUCT_LIBRARY_NAME PRODLIB VARCHAR(10)
Nullable
 The name of the library that is used as the product library during the processing of the command. Can contain the following special value:
*NOCHG
The product library does not change for the processing of this command.

Contains the null value if there is no product library used during the processing of the command, or if PROXY_COMMAND is YES.
MAXIMUM_POSITIONAL_PARAMETERS MAXPOS INTEGER
Nullable
 The maximum number of parameters that can be coded in a positional manner for this command.

Contains the null value if no maximum positional coding limit was specified for the command, or if PROXY_COMMAND is YES.
ALLOW_LIMITED_USER ALWLMTUSR VARCHAR(3)
Nullable
 Whether a user whose profile is set for limited capabilities is allowed to use the command by typing it in the command line on a menu.
NO
This command cannot be entered in the command line on a menu by a user whose profile is set for limited capabilities.
YES
This command can be entered in the command line on a menu by a user whose profile is set for limited capabilities.

Contains the null value if PROXY_COMMAND is YES.
DEBUG_MODE DEBUG_MODE VARCHAR(3)
Nullable
 Whether the command is valid for debug mode operations.
NO
The command is not valid for debug mode operations.
YES
The command is valid for debug mode operations.

Contains the null value if PROXY_COMMAND is YES.
PRODUCTION_MODE PROD_MODE VARCHAR(3)
Nullable
 Whether the command is valid for production mode operations.
NO
The command is not valid for production mode operations.
YES
The command is valid for production mode operations.

Contains the null value if PROXY_COMMAND is YES.
SERVICE_MODE SVC_MODE VARCHAR(3)
Nullable
 Whether the command is valid for service mode operations.
NO
The command is not valid for service mode operations.
YES
The command is valid for service mode operations.

Contains the null value if PROXY_COMMAND is YES.
ALLOW_RUN_INTERACTIVE ALLOWINTER VARCHAR(3)
Nullable
 Whether the command can be processed interactively, external to a CL program.
NO
The command is not allowed to run in an interactive job.
YES
The command is allowed to run in an interactive job.

Contains the null value if PROXY_COMMAND is YES.
ALLOW_RUN_BATCH ALLOWBATCH VARCHAR(3)
Nullable
 Whether the command can be processed in a batch input stream, external to a CL program.
NO
The command is not allowed to run in a batch job.
YES
The command is allowed to run in a batch job.

Contains the null value if PROXY_COMMAND is YES.
ALLOW_RUN_EXEC ALLOWEXEC VARCHAR(3)
Nullable
 Whether the command can be used as a parameter on the CALL command and be passed as a character string to the system API programs QCMDEXC, QCAEXEC, and QCAPCMD for processing.
NO
The command is not allowed to run by using QCMDEXC, QCAEXEC, or QCAPCMD API programs.
YES
The command is allowed to run by using QCMDEXC, QCAEXEC, or QCAPCMD API programs.

Contains the null value if PROXY_COMMAND is YES.
ALLOW_RUN_BATCH_ENTRY ALLOWBPGM VARCHAR(3)
Nullable
 Whether the command can be processed in a CL program that is called from batch entry.
NO
The command is not allowed to run in a batch program.
YES
The command is allowed to run in a batch program.

Contains the null value if PROXY_COMMAND is YES.
ALLOW_RUN_INTERACTIVE_ENTRY ALLOWIPGM VARCHAR(3)
Nullable
 Whether the command can be processed in a CL program that is called from interactive entry.
NO
The command is not allowed to run in an interactive program.
YES
The command is allowed to run in an interactive program.

Contains the null value if PROXY_COMMAND is YES.
ALLOW_RUN_BATCH_PGM ALLOWBMOD VARCHAR(3)
Nullable
 Whether the command can be used in a batch ILE CL program.
NO
The command is not allowed to run in a batch ILE CL program.
YES
The command is allowed to run in a batch ILE CL program.

Contains the null value if PROXY_COMMAND is YES.
ALLOW_RUN_INTERACTIVE_PGM ALLOWIMOD VARCHAR(3)
Nullable
 Whether the command can be used in an interactive ILE CL program.
NO
The command is not allowed to run in an interactive ILE CL program.
YES
The command is allowed to run in an interactive ILE CL program.

Contains the null value if PROXY_COMMAND is YES.
ALLOW_RUN_BATCH_REXX ALLOWBREXX VARCHAR(3)
Nullable
 Whether the command can be used in a REXX procedure run in a batch job.
NO
The command is not allowed to run in a batch REXX job.
YES
The command is allowed to run in a batch REXX job.

Contains the null value if PROXY_COMMAND is YES.
ALLOW_RUN_INTERACTIVE_REXX ALLOWIREXX VARCHAR(3)
Nullable
 Whether the command can be used in a REXX procedure run in an interactive job.
NO
The command is not allowed to run in an interactive REXX job.
YES
The command is allowed to run in an interactive REXX job.

Contains the null value if PROXY_COMMAND is YES.
CCSID CCSID INTEGER
Nullable
 The value of the coded character set identifier (CCSID) associated with this command. It is the value of the job CCSID when this command was created.

Contains the null value if PROXY_COMMAND is YES.
GUI_ENABLED GUI_ENB VARCHAR(3)
Nullable
 Whether the command prompt panels are enabled for conversion to a graphical user interface.
NO
The command prompt panels are not enabled for conversion to a graphical user interface.
YES
The command prompt panels are enabled for conversion to a graphical user interface by including information about the panel content in the 5250 data stream.

Contains the null value if PROXY_COMMAND is YES.
THREADSAFE THREADSAFE VARCHAR(5)
Nullable
 Whether the command can be used safely in a multithreaded job.
*COND
The command is threadsafe under certain conditions.
*NO
The command is not threadsafe and should not be used in a multithreaded job.
*YES
The command is threadsafe and can be used safely in a multithreaded job.

Contains the null value if PROXY_COMMAND is YES.
MULTITHREADED_JOB_ACTION JOB_ACTION VARCHAR(7)
Nullable
 The action to take in a multithreaded job for this command.
*MSG
Send an informational message and run the command.
*NORUN
Send an escape message, and do not run the command.
*RUN
Run the command. Do not send a message.
*SYSVAL
Use the action specified in QMLTTHDACN system value.

Contains the null value if PROXY_COMMAND is YES.
TARGET_RELEASE TGTRLS CHAR(6)
Nullable
 The version, release, and modification level to which this command is restricted in VxRxMx format. This applies only to a command used in a CL program. It must match the contents of the target release parameter on the Create CL Program (CRTCLPGM) command.

Contains the null value if the current release is used, or if PROXY_COMMAND is YES.

Example

  • List all the proxy commands in QSYS.
    
SELECT *
    FROM QSYS2.COMMAND_INFO
    WHERE COMMAND_LIBRARY = 'QSYS'
          AND PROXY_COMMAND = 'YES';
End of change