Now, Get RPG Codes in all three formats only on this website on every RPGLE related programming article.

Fixed, /Free and Fully Free RPG


Work with Spooled Files (WRKSPLF) in AS400

Work with Spooled Files (WRKSPLF) in AS400
Work with Spooled Files (WRKSPLF) in AS400, work with spool file, WRKSPLF, spool file, as400, ibmi, as400 jobs, introduction, about, what
Work with Spooled Files (WRKSPLF) in AS400

WRKSPLF

Work with Spool Files (WRKSPLF) commands show the list of all the spool files available on the system or the selected list from them.

                         Work with All Spooled Files                          
                                                                              
Type options, press Enter.                                                    
  1=Send   2=Change   3=Hold   4=Delete   5=Display   6=Release   7=Messages  
  8=Attributes        9=Work with printing status                             
                                                                              
                                                                              
                             Device or                     Total     Cur      
Opt  File        User        Queue       User Data   Sts   Pages    Page  Copy
_    DDL101      EASYCLASS   EASYCLASS   SQL         RDY       3             1
_    READTEXT    EASYCLASS   EASYCLASS   CRTSQLRPGI  RDY       2             1
_    READTEXT    EASYCLASS   EASYCLASS               RDY      12             1
_    READTEXT    EASYCLASS   EASYCLASS   CRTSQLRPGI  RDY       2             1
_    READTEXT    EASYCLASS   EASYCLASS               RDY      13             1
_    READTEXT    EASYCLASS   EASYCLASS   CRTSQLRPGI  RDY       2             1
_    READTEXT    EASYCLASS   EASYCLASS               RDY      12             1
_    READTEXT    EASYCLASS   EASYCLASS   CRTSQLRPGI  RDY       2             1
_    READTEXT    EASYCLASS   EASYCLASS               RDY      13             1
                                                                       More...
Parameters for options 1, 2, 3 or command                                     
===> __________________________________________________________________________                                                                         
F3=Exit   F10=View 4   F11=View 2   F12=Cancel   F22=Printers   F24=More keys 

You can choose the options to change, hold, delete, display, or release any or all of the entries that are shown above.

Work with All the spool files

The below command will display the Work with Spooled Files panel that will show the list of all the spooled files available on the system.

WRKSPLF   SELECT(*ALL *ALL *ALL *ALL *ALL *ALL)  DSPFMT(*NORMAL)

Work with selected spool files

The below command allows us to work with all the spooled files on the system for the current user and that have 'SQL' specified in the user data for the spooled file.

WRKSPLF SELECT(*CURRENT *ALL *ALL SQL *ALL *ALL)

The above command will show the below output.

                         Work with All Spooled Files                          
                                                                              
Type options, press Enter.                                                    
  1=Send   2=Change   3=Hold   4=Delete   5=Display   6=Release   7=Messages  
  8=Attributes        9=Work with printing status                             
                                                                              
                                                                              
                             Device or                     Total     Cur      
Opt  File        User        Queue       User Data   Sts   Pages    Page  Copy
 _   DDL101      EASYCLASS   EASYCLASS   SQL         RDY       3             1
 _   DDL80       EASYCLASS   EASYCLASS   SQL         RDY       3             1
 _   DDL80       EASYCLASS   EASYCLASS   SQL         RDY       3             1
 _   DDL80       EASYCLASS   EASYCLASS   SQL         RDY       3             1
 _   DDL80       EASYCLASS   EASYCLASS   SQL         RDY       3             1
 _   DDL80       EASYCLASS   EASYCLASS   SQL         RDY       3             1
 _   DDL80       EASYCLASS   EASYCLASS   SQL         RDY       3             1
 _   DDL80       EASYCLASS   EASYCLASS   SQL         RDY       3             1
 _   DDL80       EASYCLASS   EASYCLASS   SQL         RDY       3             1
                                                                       More...
Parameters for options 1, 2, 3 or command                                     
===> _________________________________________________________________________                                                                         
F3=Exit   F10=View 4   F11=View 2   F12=Cancel   F22=Printers   F24=More keys 

Work with spooled files by Date

The below command allows us to work with all the spooled files on the system for the current user that have a created date and time between the following dates and time ('05:01:15' '12/15/2021') ('04:35:46' '12/18/2021').

WRKSPLF SELECT(*CURRENT *ALL *ALL *ALL *ALL *ALL) PERIOD(('05:01:15' '12/15/2021') ('04:35:46' '12/18/2021'))

The above command will show the below output.

                         Work with All Spooled Files                          
                                                                              
Type options, press Enter.                                                    
  1=Send   2=Change   3=Hold   4=Delete   5=Display   6=Release   7=Messages  
  8=Attributes        9=Work with printing status                             
                                                                              
                                                                              
                                              Creation  Creation              
Opt  File        User        Form Type   Pty  Date      Time                  
 _   RPGLE11#1   EASYCLASS   *STD         5   12/16/21  19:28:57              
 _   RPGLE11#1   EASYCLASS   *STD         5   12/16/21  19:29:07              
 _   RPGLE11#1   EASYCLASS   *STD         5   12/16/21  19:31:04              
 _   RPGLE11#2   EASYCLASS   *STD         5   12/16/21  19:36:50              
 _   RPGLE11#2   EASYCLASS   *STD         5   12/16/21  19:38:34              
 _   RPGLE11#2   EASYCLASS   *STD         5   12/16/21  19:39:39              
 _   RPGLE7#1    EASYCLASS   *STD         5   12/16/21  20:42:15              
 _   RPGLE7#1    EASYCLASS   *STD         5   12/16/21  20:42:45              
 _   RPGLE7#1    EASYCLASS   *STD         5   12/16/21  20:43:32              
                                                                       More...
Parameters for options 1, 2, 3 or command                                     
===> _______________________________________________________________________                                                                         
F3=Exit   F10=View 1   F11=View 3   F12=Cancel   F22=Printers   F24=More keys 

Related Post

Post a Comment

© AS400 and SQL Tricks. All rights reserved. Developed by Jago Desain