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).