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.

Authorization: Rows will be returned for output queues when the caller has:

Execute authority to the output queue library and
- Read authority to the output queue object, or
- *JOBCTL special authority and the output queue has OPRCTL(*YES), or
- *SPLCTL special authority

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

Table 1. OUTPUT_QUEUE_INFO view
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. FIFO The queue is first-in first-out for each file. That is, on the queue, new spooled files are placed behind all other spooled files that have the same priority. JOBNBR The queue entries for the spooled files are sorted in priority sequence using the job number (the date and time that the job entered the system) of the job that created the spooled file.
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. NO Users authorized to the queue can only display, copy, or send their own spooled files, unless one of the following applies: they have SPLCTL special authority, or they have JOBCTL special authority and OPERATOR_CONTROLLED is YES. OWNER Only the owner of a file or a user with SPLCTL authority can display, copy, send, or move their own spooled files to another output queue. *YES Any user having authority to read the queue can display, copy, or send the data of any file on the queue.
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: *MSG No job separators are used; instead a message is sent to the writer's message queue at the end of each job indicating that the output can be removed.
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. NO This queue and its entries cannot be controlled or changed by users with job control authority unless they also have some other special authority. *YES Users with job control authority can control the queue and make changes to the files on the queue.
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. DTAAUT Any user with READ, ADD, and DELETE authority to the output queue can control all output files on the queue. *OWNER Only the owner of the output queue can control all the output 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. HELD The queue is held. RELEASED The queue is released.
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. END The writer job has ended. HLD The writer job is held. JOBQ The writer job is on the job queue. MSGW The writer job is waiting for a message response. STR The writer job is started for the output queue. 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. PRINTER Printer writer. REMOTE Remote writer. 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. OUTQASP The spooled files reside in the auxiliary storage pool in which the output queue resides. SYSTEM The spooled files reside in the system auxiliary storage pool.
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: *SYSBAS The spooled files resides in the system ASP (ASP 1) or one of the defined basic user ASPs (ASPs 2-32). 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: *LIBL The library list is searched to find the message queue. 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. NO Do not transform data streams using host print transform. YES Transform data streams using host print transform. 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. IP The TCP/IP network is used as the connectivity to the remote system. SNA The SNADS network is used as the connectivity to the remote system. *USRDFN A user-defined connectivity is used as the connectivity 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. NDS The destination is Novell NetWare 3 or 4, and the connection type is USRDFN. OS400 The destination system is an IBM i. OTHER The destination system does not match any of the other special values. This is commonly used when the destination is a printer. PSF2 The destination system is a PC using Print Services Facility/2. S390 This destination system is a System/390® system. 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: SYSTEM The default system printer on the remote system will determine the printer queue. USER The user profile that creates the spooled file will determine the user ID on the remote system that it is sent to. 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: NOWAIT The remote writer will not wait for confirmation that the destination system has finished processing the spooled file. USRDFNTXT Use the value for the user-defined text of the user profile when the spooled file was created. 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: CURLIB The current library for the job is used to locate the user driver program. LIBL The library list used to locate the user driver program. 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: CURLIB The current library for the job is used to locate the user-defined object. LIBL The library list used to locate the user-defined object. 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. DTAARA Data area. DTAQ Data queue. FILE File. PSFCFG PSF configuration object. USRIDX User index. USRQ User queue. *USRSPC User space. 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: CURLIB The current library for the job is used to locate the data transform program. LIBL The library list used to locate the data transform program. 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. NO Output queue is not published. YES Output queue is published.
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: PRTF The first 8 characters of the printer file used to spool the file determines the name of the FCB. USRDTA The first 8 characters of the user data (USRDATA) spooled file attribute determines the name of the FCB. If the user data is blank, no FCB is used. 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