Start of change

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.

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

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

Table 1. COMMUNICATIONS_ENTRY_INFO view
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:
*ALL
All communications device types are used with this communications entry.
*APPC
All advanced program-to-program communications devices can be used with this communications entry.
*ASYNC
All asynchronous communications devices can be used with this communications entry.
*BSCEL
All bisynchronous equivalency link communications devices can be used with this communications entry.
*FINANCE
All finance communications devices can be used with this communications entry.
*INTRA
All intrasystem communications devices can be used with this communications entry.
*RETAIL
All retail communications devices can be used with this communications entry.
*SNUF
All SNA upline facility communications devices can be used with this communications entry.

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:
*ANY
Any available modes defined to the communications device are allocated to the subsystem. If the communications device does not have defined modes associated with it, the communications device itself is allocated to the subsystem.
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:
*USRPRF
The job description name that is specified in the user profile of the user that made the program start request is used for jobs that are processed through this communications entry.
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:
*SYS
All user program start requests are treated the same as if no user profile is specified as the default. For program start requests that are sent by system functions, the request runs under a predetermined user profile if a user profile is not specified on the program start request.

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';
End of change