OUTPUT_QUEUE_INFO view
The OUTPUT_QUEUE_INFO view returns one row for each output queue.
The values returned for the columns in the view are similar to the values returned by the Retrieve Output Queue Information (QSPROUTQ) API. Refer to the API for more detailed information.
- *EXECUTE authority to the library containing the output queue, and
- *READ authority to the output queue object, or
- *SPLCTL special authority, or
- *JOBCTL special authority and the output queue is defined with OPRCTL(*YES).
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
OUTPUT_QUEUE_NAME | OUTQ | VARCHAR(10) | Name of the output queue. |
OUTPUT_QUEUE_LIBRARY_NAME | OUTQLIB | VARCHAR(10) | The name of the library that contains the output queue. |
NUMBER_OF_FILES | FILES | INTEGER | The total number of spooled files currently on this output queue. |
NUMBER_OF_WRITERS | WRITERS | INTEGER | The number of printer writers that have been started to this output queue. |
WRITERS_TO_AUTOSTART | AUTOSTART | INTEGER | The number of remote printer writers to autostart to this output queue at system IPL. |
PRINTER_DEVICE_NAME | DEV_NAME | VARCHAR(10) Nullable
|
The name of the printer device.
If more than one writer is started, this is the printer device name
of the first writer. Contains the null value if WRITER_TYPE is not PRINTER. |
ORDER_OF_FILES | FILE_ORDER | VARCHAR(7) | The order of the spooled files
on the output queue.
|
DISPLAY_ANY_FILE | ANYFILE | VARCHAR(6) | Whether users who have authority
to read this output queue can display the output data of any output
file on this queue, or only the data in their own files.
|
JOB_SEPARATORS | JOB_SEP | VARCHAR(4) | The number of job separators (0-9)
to be placed at the beginning of the output for each job having spooled
file entries on this output queue. Can also contain the following
special value:
|
MAXIMUM_PAGES | MAX_PAGES | INTEGER Nullable
|
Only spooled files with this number
of pages or less will print between MAXIMUM_PAGES_STARTING_TIME and
MAXIMUM_PAGES_ENDING_TIME. If more than one set of maximum spooled
file size values is defined for this output queue, only information
for the first set is returned. Contains the null value if no maximum spooled file size is defined. |
MAXIMUM_PAGES_STARTING_
TIME |
MAX_START | TIME Nullable
|
The starting time, in local job
time, that spooled files exceeding MAXIMUM_PAGES will be restricted
from printing. If a spooled file exceeds the page limit it will be
in deferred status until ENDING_TIME. Contains the null value if no maximum spooled file size is defined. |
MAXIMUM_PAGES_ENDING_
TIME |
MAX_END | TIME Nullable
|
The ending time, in local job time,
when spooled files exceeding MAXIMUM_PAGES will be allowed to print. Contains the null value if no maximum spooled file size is defined. |
OPERATOR_CONTROLLED | OPR_CTRL | VARCHAR(4) | Whether users with job control
authority are allowed to manage or control the files on this queue.
Users have job control authority if SPCAUT(*JOBCTL) is specified in
their user profile.
|
AUTHORITY_TO_CHECK | ALL_AUTH | VARCHAR(7) | Indicates what type of authorities
to the output queue allow the user to control all the files on the
queue.
|
DATA_QUEUE_LIBRARY | DTAQ_LIB | VARCHAR(10) Nullable
|
The name of the library containing
the data queue. Contains the null value if no data queue is associated with this output queue. |
DATA_QUEUE_NAME | DTAQ_NAME | VARCHAR(10) Nullable
|
The name of the data queue associated
with this output queue. Contains the null value if no data queue is associated with this output queue. |
OUTPUT_QUEUE_STATUS | STATUS | VARCHAR(8) | The status of the output queue.
|
WRITER_JOB_NAME | WRITER_JOB | VARCHAR(28) Nullable
|
The qualified job name of the writer
job. If more than one writer is started, this is the name of the first
writer. Contains the null value if a writer job is not started for this queue. |
WRITER_JOB_STATUS | WRITER_STS | VARCHAR(4) Nullable
|
The status of the writer job. If
more than one writer is started, this is the status of the first writer.
Contains the null value if a writer job is not started for this queue. |
WRITER_TYPE | WRITER_TYP | VARCHAR(7) Nullable
|
The type of writer started for
this output queue.
Contains the null value if a writer job is not started for this queue. |
SPOOLED_FILE_ASP_ATTRIBUTE | ASP_ATTR | VARCHAR(8) | The auxiliary storage pool (ASP)
where the spooled files are to reside.
|
SPOOLED_FILE_ASP_NUMBER | ASPNUM | INTEGER | The number of the auxiliary storage pool (ASP) where the spooled files reside. |
SPOOLED_FILE_ASPGRP | ASPGRP | VARCHAR(10) Nullable
|
The name of the auxiliary storage
pool (ASP) device where the spooled files reside. Can also contain
the following special value:
Contains the null value if the name is not available. |
TEXT_DESCRIPTION | TEXT | VARCHAR(50) Nullable
|
The text description of the output
queue. Contains the null value if the output queue has no description. |
MESSAGE_QUEUE_LIBRARY | MSGQ_LIB | VARCHAR(10) Nullable
|
The name of the library containing
the message queue. Can contain the following special value:
Contains the null value if the output queue is not a remote output queue or if WRITER_TYPE is PRINTER. |
MESSAGE_QUEUE_NAME | MSGQ_NAME | VARCHAR(10) Nullable
|
The name of the message queue to
which messages, created by the remote writer started to this output
queue, are sent. Contains the null value if the output queue is not a remote output queue or if WRITER_TYPE is PRINTER. |
HOST_PRINT_TRANSFORM | TRANSFORM | VARCHAR(4) Nullable
|
Whether to use the host print transform
function to transform a spooled file.
Contains the null value if NETWORK_CONNECTION_TYPE is *SNA and USER_DRIVER_PROGRAM_NAME is null. |
IMAGE_CONFIGURATION_NAME | IMAGE_NAME | VARCHAR(10) Nullable
|
The name of the image configuration. Contains the null value if no image configuration is used when transforming the spooled file before sending. |
MANUFACTURER_TYPE_AND_
MODEL |
TYPE_MODEL | VARCHAR(17) Nullable
|
The manufacturer, type, and model
for a printer using the host print transform function. See Printer Model Settings for Host Print Transform (HPT) in the IBM® Support Portal for the list of supported values. Contains the null value when NETWORK_CONNECTION_TYPE is *SNA, or when NETWORK_CONNECTION_TYPE is *IP and HOST_PRINT_TRANSFORM is *NO. |
WORKSTATION_CUSTOMIZING_
OBJECT_LIBRARY |
CUSTOM_LIB | VARCHAR(10) Nullable
|
The library name for the workstation
customizing object. Contains the null value if there is no workstation customizing object or if NETWORK_CONNECTION_TYPE is *SNA and USER_DRIVER_PROGRAM_NAME is null. |
WORKSTATION_CUSTOMIZING_
OBJECT_NAME |
CUSTOM_NAM | VARCHAR(10) Nullable
|
The name of an object that consists
of a table of attributes used to customize a given ASCII device. Contains the null value if there is no workstation customizing object or if NETWORK_CONNECTION_TYPE is *SNA and USER_DRIVER_PROGRAM_NAME is null. |
NETWORK_CONNECTION_TYPE | NET_TYPE | VARCHAR(7) Nullable
|
The type of network connection
to the remote system.
Contains the null value if the output queue is not a remote output queue. |
DESTINATION_TYPE | DEST_TYPE | VARCHAR(8) Nullable
|
The type of destination system
that spooled files on this output queue are being sent to.
Contains the null value if the output queue is not a remote output queue. |
REMOTE_SYSTEM_NAME | REMOTE_NAM | VARCHAR(255) Nullable
|
The name of the remote system. Contains the null value if the output queue is not a remote output queue. |
REMOTE_PRINTER_QUEUE | REMOTE_PRT | VARCHAR(255) Nullable
|
The name of the remote printer.
Can also contain one of these special values:
Contains the null value if the output queue is not a remote output queue. |
INTERNET_ADDRESS | IP_ADDRESS | VARCHAR(15) Nullable
|
The internet address of the remote system to which the print
request will be sent. Contains the null value if the output queue is not a remote output queue. |
DESTINATION_OPTIONS | DEST_OPT | VARCHAR(128) Nullable
|
Destination-dependent options that
are specific to a particular implementation of an LPR Print Server.
Can also contain the special values:
Contains the null value if the output queue is not a remote output queue. |
USER_DRIVER_PROGRAM_
LIBRARY |
UDP_LIB | VARCHAR(10) Nullable
|
The name of the library that contains
the user driver program. Can also be one of these special values:
Contains the null value if no user driver program is specified. |
USER_DRIVER_PROGRAM_NAME | UDP_NAME | VARCHAR(10) Nullable
|
The name of the user-specified
driver program that is used to process the spooled files on the output
queue. Contains the null value if no user driver program is specified. |
USER_DEFINED_OBJECT_LIBRARY | UDO_LIB | VARCHAR(10) Nullable
|
The name of the library that contains
the user-defined object. Can also be one of these special values:
Contains the null value if no user-defined object is specified. |
USER_DEFINED_OBJECT_NAME | UDO_NAME | VARCHAR(10) Nullable
|
The name of the user-defined object
that is used by user applications or user-specified programs that
process spooled files. Contains the null value if no user-defined object is specified. |
USER_DEFINED_OBJECT_TYPE | UDO_TYPE | VARCHAR(7) Nullable
|
The type of the user-defined object.
Contains the null value if no user-defined object is specified. |
DATA_TRANSFORM_PROGRAM_
LIBRARY |
DTP_LIB | VARCHAR(10) Nullable
|
The name of the library that contains
the data transform program. Can also be one of these special values:
Contains the null value if no data transform program is specified. |
DATA_TRANSFORM_PROGRAM_
NAME |
DTP_NAME | VARCHAR(10) Nullable
|
The name of the user-specified
data transform program that is used by the driver program. Contains the null value if no data transform program is specified. |
USER_DEFINED_OPTION_1 | UDEF_OPT1 | VARCHAR(10) Nullable
|
The first user-defined option. Contains the null value if there are no user-defined options. |
USER_DEFINED_OPTION_2 | UDEF_OPT2 | VARCHAR(10) Nullable
|
The second user-defined option. Contains the null value if there are not at least two user-defined options. |
USER_DEFINED_OPTION_3 | UDEF_OPT3 | VARCHAR(10) Nullable
|
The third user-defined option. Contains the null value if there are not at least three user-defined options. |
USER_DEFINED_OPTION_4 | UDEF_OPT4 | VARCHAR(10) Nullable
|
The fourth user-defined option. Contains the null value if there are not at least four user-defined options. |
USER_DEFINED_DATA | UDEF_DATA | VARBINARY(5000) Nullable
|
Data defined by the user to be
used by user applications or user-specified programs that process
spooled files. Contains the null value if there is no user-defined data. |
LDAP_PUBLISHING_STATUS | PUBLISHED | VARCHAR(3) | Whether the output queue is published
in the network directory.
|
FORMS_CONTROL_BUFFER | FORMS_BUF | VARCHAR(8) Nullable
|
The forms control buffer (FCB) for files sent to a VM/MVS™ host system. Contains either the name of the FCB or one of the following special values:
Contains the null value if no FCB is used when sending spooled files or if NETWORK_CONNECTION_TYPE is not *SNA or DESTINATION_TYPE is not *S390. |
VM_MVS_CLASS | VM_CLASS | CHAR(1) Nullable
|
The VM/MVS SYSOUT class for distributions sent to a VM host system or to a MVS host system. Values are A-Z, 0-9 to indicate the distribution class. Contains the null value if not defined for this output queue. |
Example
SELECT * FROM QSYS2.OUTPUT_QUEUE_INFO