COMMUNICATIONS_ENTRY_INFO view
The COMMUNICATIONS_ENTRY_INFO view returns information about subsystem communications entries.
The values returned for the columns in the view are closely related to the values returned by the Display Communications Entries and Display Remote Location Name Entries panels accessed through the DSPSBSD (Display Subsystem Description) CL command and by the List Subsystem Entries (QWDLSBSE) API.
- *EXECUTE authority to the library containing the subsystem description, and
- *USE authority to the subsystem description.
The following table describes the columns in the view. The system name is COMM_INFO. The schema is QSYS2.
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
SUBSYSTEM_DESCRIPTION_LIBRARY | SBSD_LIB | VARCHAR(10) | The name of the library in which the subsystem description resides. |
SUBSYSTEM_DESCRIPTION | SBSD | VARCHAR(10) | The name of the subsystem about which information is being returned. |
DEVICE | DEVICE | VARCHAR(10) Nullable
|
The name of the device description or the type of the device being
used with this communications entry. Can contain the following special values:
Contains the null value if this entry was defined using a remote location name. |
REMOTE_LOCATION | RMT_LOC | VARCHAR(8) Nullable
|
The name of the remote location for this entry. Contains the null value if this entry was defined using a device description name. |
MODE | MODE | VARCHAR(8) | The mode name of the communications device. Can contain the
following special value:
|
JOB_DESCRIPTION_LIBRARY | JOBDLIB | VARCHAR(10) Nullable
|
The name of the library in which the communications entry job
description resides. Contains the null value if JOB_DESCRIPTION is *USRPRF. |
JOB_DESCRIPTION | JOBD | VARCHAR(10) | The name of the job description used when a job is started as a
result of receiving a program start request and processed through this communications entry. Can
contain the following special value:
|
DEFAULT_USER | DFT_USER | VARCHAR(10) Nullable
|
The name of the default user profile used for evoke requests that
enter the subsystem through this entry and contain no security information. Can contain the
following special value:
Contains the null value if no user profile is specified as the default. |
MAXIMUM_ACTIVE_JOBS | MAX_ACTIVE | INTEGER Nullable
|
The maximum number of jobs that can be active at the same time
through this entry. Contains the null value if the entry specifies *NOMAX, indicating that there is no maximum. |
Example
- List all the communications entries defined for the QCMN
subsystem.
SELECT * FROM QSYS2.COMMUNICATIONS_ENTRY_INFO WHERE SUBSYSTEM_DESCRIPTION_LIBRARY = 'QSYS' AND SUBSYSTEM_DESCRIPTION = 'QCMN';