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';