Simple. Effective. Affordable. Your trusted IBM Midrange Partner for over 10 years...

Chapter 2 - SPLTOOL Display Options

The SPLTOOL display contains many options that make copying page ranges and trasferring spooled easy. The display is designed to be user friendly and easy to use. If a user is familiar with either the WRKOUTQ or WRKSPLF command displays, working with SPLTOOL will seem like second nature.

Along with the basic options found in the WRKOUTQ and WRKSPLF commands, SPLTOOL has a few more options defined to perform certain tasks. What also makes SPLTOOL very versitile is the ability to create user defined options similar to the way you can create them in PDM. More on creating and using user defined options is discussed in Chapter 8.

SPLTOOL can also remove standard headings from reports when copying a spooled file with the folder, stream file, or FTP options. Click here for instructions.

Your display may or may not have all the options shown here. The Spooled File Tools Configuration (SPLTOOLCFG) command can be used by your system administrator to limit the options for each user.

The following figure shows the SPLTOOL display and the options that are available.


  2/26/00                 Spooled File Tools (SPLTOOL)
 11:09:40

 Queue . . . . . . PRT01                User Name . . . . . . *CURRENT
   Library . . . .   *LIBL              User Data . . . . . . *ALL
                                        Form Type . . . . . . *ALL
 Type options, press Enter.
  1=Print Range    2=Copy to PC folder     3=Hold   5=Display   6=Release
  7=Copy to file   8=Copy to Stream File   9=FTP Spooled File   10=E-Mail


                             Total  Device or
 Opt  File       User        Pages  Queue      User Data  Form Type  Status
 __   QPDZDTALOG BSTONE          1  PRT01                 *STD       *READY
 __   INVRPTPT   BSTONE         13  PRT01                 *STD       *READY
 __   INVRPT2PT  BSTONE          2  PRT01                 *STD       *READY
 __   QPDZDTALOG BSTONE          1  PRT01                 *STD       *READY
 __   SAMPLEPT   BSTONE          1  PRT01                 *STD       *READY



                                                                         Bottom
  F3=Exit   F5=Refresh   F6=WRKSPLF   F7=WRKOUTQ   F9=FTP Status   F11=View
  F16=User Options       F17=Top      F18=Bottom   F23=Change Defaults

 

As shown in the previous figure, the following options are available for use with the SPLTOOL display:

  • Print Range - Use this option to create a duplicate of the specified spooled file. With this option you are able to select a range of pages to duplicate as well as the target output queue. This option has the option to be performed interactively or in batch.
  • Copy to Folder - Use this option to copy a spooled file to a folder.
  • Hold - Use this option to change the status of the spooled file to *HOLD.
  • Delete - Use this option to delete a spooled file. A verification screen will be shown before the spooled file is deleted.
  • Display - Use this option to display the contents of the spooled file.
  • Release - Use this option to release a held or saved spooled file to be printed.
  • Copy to file - Use this option to copy a spooled file to a physical file.
  • Copy to Stream File - Use this option to copy a spooled file to a stream file that will reside in a directory in the Integrated File System (IFS).
  • FTP Spooled File - Use this option to send a spooled file to another machine using the File Transfer Protocol (FTP) method. The machine that you send the spooled file to must be running an FTP server.
  • EMail - Use this option to email the spooled file as an attachement. This option is a seperate download and requires V4R3 or higher of the operating system.

Following are screen examples of each of the options unique to SPLTOOL and an explanation of the parameters.


Print Range

                Print Spooled File Range (PRTRNG)

 Job        User       Number   File       Number  Pages
 QPADEV000R BSTONE     101616   INVRPTPT   0001       13

 Page range:                   Destination:
   Starting Page . . .      1    Output Queue . . PRT01
   Ending Page . . . .     13      Library  . . .   QUSRSYS

 Copies  . . . . . . .      1    Hold . . . . . . *SAME
                                 Save . . . . . . *SAME
 Process in batch  . . N

 F12=Cancel
  • Starting Page - Enter the starting page number to copy.
  • Ending Page - Enter the ending page number to copy.
  • Output Queue - Enter the output queue and library where you want the new spooled file to reside.
  • Copies - Enter the number of copies you wish to make. This parameter changes the Copies parameter of the spooled file generated.
  • Hold - Enter the hold status for the new spooled file. *SAME will have the same status as the original, *YES and *NO will set the hold attribute of the new spooled file accordingly.
  • Save - Enter the save attribute. *SAME will have the same status as the original, *YES and *NO will set the save attribute of the new spooled file accordingly.
  • Process in batch - Enter N to process interactivley or enter Y to process the command in batch.

Copy to Folder

                 Spooled File To Folder (SPL2FLR)

 Job        User       Number     File       Number  Pages
 QPADEV000R BSTONE     101616     INVRPTPT   0001       13

 Page range:                    Desitnation:
   Starting Page . . .      1     File Name  . . . S1616001
   Ending Page . . . .     13     Extension  . . . DOC

 Process in batch  . . N          Trans Table  . . Q037337850
                                    Library  . . .   *LIBL

 To folder:  (Example: folder1/folder2/folder3/.../foldern)
 BSTONE_______________________________________________________
 Title: (.htm extension only)
 _____________________________________________________________

 F12=Cancel   F17=Select Lines
  • Starting Page - Enter the starting page number to copy.
  • Ending Page - Enter the ending page number to copy.
  • Process in batch - Enter N to process interactivley or enter Y to process the command in batch.
  • File Name - Enter the file name of the new document.
  • Extension - Enter the extension of the new document.
  • Trans Table - Enter the library and name of the translation table you wish to use during the conversion to a document.
  • To folder - Enter the name of the folder that exists on your AS/400 that you wish the new document to be created in. The folder must exist. To check for the existance of the folder, use the Work with Folders (WRKFLR) command.
  • Title - Enter the title of the document if you are copying the new file to an .htm (web page) extension. This will set the title of the report.

Copy to file

             Spooled File to Physical File (SPL2PF)

 Job        User       Number   File       Number  Pages
 QPADEV000R BSTONE     101616   INVRPTPT   0001       13

 Page range:                    Destination:
   Starting Page . . .      1     File . . . . . . QPDZDTALOG
   Ending Page . . . .     13       Library  . . .   QGPL

 Process in batch  . . N

 F12=Cancel
  • Starting Page - Enter the starting page number to copy.
  • Ending Page - Enter the ending page number to copy.
  • Process in batch - Enter N to process interactivley or enter Y to process the command in batch.
  • File - Enter the file name and library where you want to copy the spooled file to.

Copy to Stream File

              Spooled File to Stream File (SPL2STMF)

 Job        User       Number      File       Number  Pages
 QPADEV000S BSTONE     101616      INVRPTPT   0001       13

 Page range:                    Options:
   Starting Page . . .      1     Create Dir . . . *NO
   Ending Page . . . .     13     Replace File . . *NO
 Process in batch  . . N          Trans Table  . . Q037337850
                                    Library  . . .   *LIBL
 Code Page . . . . . . 437

 To Directory: (Example: /dir1/dir2/dir3/.../dirn/)
 /QOpenSys/____________________________________________________
 To File: (Example: filename.ext)
 QPADEV000S1018330001.DOC______________________________________
 Title: (for .htm and .html extensions only)
 ______________________________________________________________

 F12=Cancel    F17=Select Lines
  • Starting Page - Enter the starting page number to copy.
  • Ending Page - Enter the ending page number to copy.
  • Process in batch - Enter N to process interactivley or enter Y to process the command in batch.
  • Code Page - Enter the code page for the new document.
  • Create Dir - Enter *YES if you want the target directory to be created if it does not exist or *NO if you do not wish to create the directory.
  • Replace File - Enter *YES if you wish to replace the document if it already exists or *NO to not replace the document.
  • Trans Table - Enter the library and name of the translation table you wish to use during the conversion to a document.
  • To Directory - Enter the name of the directory that resides in your AS/400 IFS that you wish the new document to be created in. If the path does not exist and the Create Dir parameter is set to *YES, the path will be created.
  • To File - Enter the name of the new file you wish to create. Include the extension.
  • Title - Enter the title of the document if you are copying the new file to an .htm or .html (web page) extension. This will set the title of the report.

FTP Spooled File

                        Spooled File to FTP (SPL2FTP)

 Job        User       Number    File       Number  Pages
 QPADEV000R BSTONE     101616    QPDZDTALOG 0001       13

 Page range:                     Options:
   Starting Page . . .      1      Rmt Sys:________________________
   Ending Page . . . .     13      User ID:________________________
                                   PassWd:
 Process in batch  . . N           FTP Rep: ASCII
                                   Put or Append: *PUT

 To Directory: (Example: /dir1/dir2/dir3/.../dirn/)
 ___________________________________________________________________
 To File: (Example: filename.ext)
 QPADEV000R1016160001.DOC___________________________________________
 Title (for .htm and .html extensions only)
 ___________________________________________________________________

 F12=Cancel   F17=Select Lines

  • Starting Page - Enter the starting page number to copy.
  • Ending Page - Enter the ending page number to copy.
  • Process in batch - Enter N to process interactivley or enter Y to process the command in batch.
  • Rmt Sys - Enter the IP address of server name (if it is resolvable from your AS/400) of the machine you wish to FTP the spooled file to.
  • User ID - Enter the User ID required to sign on to the remote FTP server.
  • PassWd - Enter the password required to sign on to the remote FTP server.
  • FTP Rep - Enter the FTP representation to use with the file transfer.
  • Put or Append - Enter *PUT to put the file to the remote server. If the file already exists on the target machine, it will be replaced. Enter *APP to append the file to the remote server. If the file already exists, the data will be appended to the file, otherwise the file will be created.
  • To Directory - Enter the name of the directory of the remote machine you wish the new document to be created in.
  • To File - Enter the name of the new file you wish to create. Include the extension.
  • Title - Enter the title of the document if you are copying the new file to an .htm or .html (web page) extension. This will set the title of the report.

EMail Spooled File

The Email option now uses the SPL2EMAIL command directly. See this page for parameter descriptions


Removing Standard Headings when using the Folder, Stream File, or FTP options

SPLTOOL can be used to remove standard headings from reports when copying the spooled file to a folder, a stream file, or transferring with FTP. For this option to work, the headings must be on the exact same lines on each page that you wish to transfer.

When performing one of the mentioned options in the SPLTOOL command, before processing the command you have the option to use the F17=Select Lines key. The F17 key will display a window asking you which page of the spooled file you wish to view to select lines to omit.

After selecting the page to view, you will be shown a screen with the spooled file lines and an option line next to each. To omit specific lines, simply place an "X" on the option line next to the line that you wish to omit. After you have selected the lines to omit, press enter and you will be returned to the SPLTOOL command.

Here is an example of the Select Lines display:


  2/26/00                 Spooled File Tools (SPLTOOL)
 16:16:37                         Select Lines

 Type options, press Enter.
   X=Exclude   (Leave blank to include)

Opt *...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
 _
 _
 _
 _
 _
 _  Forum       Description                                         Number of Ms
 _
 _  RPG         RPG Discussion                                                 8
 _  CL          CL Discussion                                                  3
 _  DDS         DDS Discussion                                                 7
 _  MAPICS      MAPICS Discussion                                              2
 _  JDE         JDE Discussion                                                 0
 _  BPCS        BPCS Discussion                                                1
 _  NS400Com    Netshare400.com Comments                                       3
                                                                        More...
  F3=Exit

 

<<Previous | Next>>

© Copyright 1995-2008 BVS/Tools     
Powered by the eRPG SDK