Start of change

WORKSTATION_INFO view

The WORKSTATION_INFO view returns information about workstation entries.

The values returned for the columns in the view are closely related to the values returned by the Display Work Station Name Entries and the Display Work Station Type Entries panels accessed through the DSPSBSD (Display Subsystem Description) CL command and by the List Subsystem Entries (QWDLSBSE) API.

Authorization: The caller must have:
  • *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 WRKST_INFO. The schema is QSYS2.

Table 1. WORKSTATION_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.
WORKSTATION_NAME WS_NAME VARCHAR(10)
Nullable
The name of the workstation that is used by the subsystem. It can be a generic workstation entry like DSP*.

Contains the null value if WORKSTATION_TYPE is not null.

WORKSTATION_TYPE WS_TYPE VARCHAR(10)
Nullable
The display device type. Can contain the following special values:
*ALL
All workstation devices. This includes devices with 5250, ASCII, and 327x device types.
*ASCII
ASCII display station.
*CONS
System console display. This entry overrides a device type entry that specifies the same device type as the device being used as the console.
*NONASCII
All workstation devices that use a 5250 data stream. This includes the 327x device types.

Contains the null value if WORKSTATION_NAME is not null.

JOB_DESCRIPTION_LIBRARY JOBDLIB VARCHAR(10)
Nullable
The name of the library in which the job description resides.

Contains the null value if JOB_DESCRIPTION is *USRPRF.

JOB_DESCRIPTION JOBD VARCHAR(10) The name of the job description that is used for jobs started through this workstation entry. Can contain the following special value:
*USRPRF
The job description named in the user profile of the user that signs on at this type of workstation is used for jobs started through this entry.
ALLOCATION ALLOCATION VARCHAR(7) How the workstations that are associated with this entry are allocated.
*ENTER
The workstations are not allocated when the subsystem is started. However, the interactive jobs that are associated with the workstations are allowed to enter this subsystem through the Transfer Job (TFRJOB) command.
*SIGNON
The workstations are allocated when the subsystem is started if the workstation is not already in use (signed on) in another subsystem. A sign-on prompt is displayed at each workstation that is associated with this work entry. If a workstation becomes allocated to a different subsystem, interactive jobs that are associated with the workstation are allowed to enter this subsystem through the Transfer Job (TFRJOB) command.
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 workstation entries in the QINTER subsystem.
    SELECT *
      FROM QSYS2.WORKSTATION_INFO 
      WHERE SUBSYSTEM_DESCRIPTION_LIBRARY = 'QSYS' AND 
            SUBSYSTEM_DESCRIPTION = 'QINTER';
End of change