Chapter 12 - List Spooled File Attributes (SPLATT)

The SPLATT command allows you to create a physical file that contains information used to identify spooled files on your system. This file can then be processed by one of your own applications and used to perform tasks on the spooled files that are identified in this physical file.

The file layout of the physical file that is created is as follows:

   10/22/01             List File Field Description (LSTFFD)            TS400
12:47:42 BVSTONE

File Name . . . . SPLATTPF
Library . . . . SPLTOOL
Format Descr . . Spooled File Attributes
Format Name . . . RSPLATT
File Type . . . . PF Unique Keys - N

Field Name FMT Start Lngth Dec Key Field Description
SAOUTQ A 1 10 Output Queue
SAOUTQL A 11 10 Output Queue Library
SAFILE A 21 10 Spooled File Name
SAJOB A 31 10 Spooled File Job
SAUSER A 41 10 User ID
SAJOBNUM A 51 6 Job Number
SASPLNUM B 57 9 00 Spooled File Number
SADEV A 61 10 Device
SAUSERDTA A 71 10 User Data
SASTATUS A 81 10 Status
SAPAGES B 91 9 00 Total Pages
SAFORMT A 95 10 Form Type
SADEVT A 105 10 Device Type
SAPGM A 115 10 Pgm That Opened
SAPGML A 125 10 Pgm Lib That Opened
SARECLEN B 135 9 00 Record Length
SADATE A 139 7 Date Created
SATIME A 146 6 Time Created
SAPGLEN B 152 9 00 Page Length
SAPGWD B 156 9 00 Page Width
SAFLR A 160 64 Folder
SADOC A 224 12 Document SASIZE P 236 13 02 Size in KBs SACOPIES B 243 9 00 Copies

The file that is created can be named anything you wish, and placed in any library that you wish, as long as it is not named SPLATTPF and placed in the SPLTOOL library. The file named SPLATTPF must remain in your SPLTOOL library and is used as a template to create your file.

The SPLATT command is very similar to the SPLTOOL batch commands and allows you to select spooled files based on one of many selection criteria.

               List Spooled File Attributes (SPLATT)

Type choices, press Enter.

Output queue . . . . . . . . . . __________ Name, *ALL
Library . . . . . . . . . . . *LIBL_____ Name, *LIBL
Spooled file . . . . . . . . . . __________ *ALL, generic*, Name
User Name . . . . . . . . . . . __________ *CURRENT, *ALL, Name
Job Name . . . . . . . . . . . . __________ *ALL, generic*, Name
Job Number . . . . . . . . . . . __________ *ALL, 000000-999999
Spooled File Number . . . . . . ________ *ALL, 1-9999
User data . . . . . . . . . . . __________ *ALL, User data
Form type . . . . . . . . . . . __________ *ALL, Form type
From Date (MMDDYYYY) . . . . . . *ALL______ Number, *ALL
To Date (MMDDYYYY) . . . . . . . *ALL______ Number, *ALL
To file . . . . . . . . . . . . __________ To file
Library . . . . . . . . . . . *CURLIB___ Name, *CURLIB
To member . . . . . . . . . . . __________ Name, *FIRST
Replace or Add records . . . . . *ADD______ *ADD, *REPLACE
Create file . . . . . . . . . . *NO_ *NO, *YES


F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display
F24=More keys

  • Output Queue - Enter an output queue to select spooled files from or specify *ALL for all output queues.
  • Spooled file - Enter a spooled file name to select spooled files, *ALL for all spooled files, or a generic name ending with an asterisk (*).
  • User Name - Enter a user name to select spooled files, *CURRENT to specify the current user, or *ALL to specify all user names.
  • Job Name - Enter a job name to select spooled files, *ALL to specify all job names, or a generic job name ending with an asterisk (*).
  • Job Number - Enter a job number that identifies the spooled file or *ALL to specify all job numbers.
  • Spooled file number - Enter a spooled file number to select a spooled file or *ALL to specify all spooled file numbers.
  • User Data - Enter a value to select spooled files by user data or *ALL to specify all user data attributes.
  • Form Type - Enter a value to select spooled files by form type or *ALL to specify all form type attributes.
  • From Date - Enter a value to select spooled files by form date. This is the beginning date. Specify *ALL for all spooled files.
  • To Date - Enter a value to select spooled files by form date. This is the ending date. Specify *ALL for all spooled files.
  • To File - Enter the name and library of the file you wish to create to store the spooled file attributes of the selected spooled files.
  • To Member - Enter the name of the member of the physical file created, or specify *FIRST.
  • Replace or Add Records - Specify *ADD to add records to the physical file, or *REPLACE to replace any existing records with the new information.
  • Create File - Specify *YES to have the SPLATT command create the physical file, or *NO if the file already exists. (If *NO is specified, the file must already exist and be an exact copy of the SPLATTPF file in your SPLTOOL library).
Comments