Spooled files in the workflow

Spooled files in the workflow

This section covers all topics concerning automatic processing of spooled files in the InterFormNG2 workflow:

•How to monitor an output queue.

•Load a sample spooled file in the workflow editor

•How to condition the workflow on spooled file attributes

•How to condition the workflow on spooled file contents

•How to merge a spooled file with a template.

•How to change spooled file attributes

•Spooled file actions

•Split spooled files

•Add data to spooled files via SQL

•Transform a spooled file into XML

•Transform a spooled file into Excel.

•Transform a spooled file into a new spooled file. This can e.g. be used if you want to change the contents or add data from an SQL via the function, ng:databaseLookup. Multiple examples are found here.

•If you print to an output queue on the IBM i, then you can set the attributes of the merged spooled file with the workflow component: IBM i print attribute options. You need to insert this before the print component. Here you can e.g. consider to copy the user profile of the input spooled file into e.g. the USRDTA field of the merged spooled file.

•How to use a database to move a spooled file or set output printer e.g. with the user output queue settings from InterForm400

•How to use translation file to link users with an output queue for move and print of spooled files.

•Handle large spooled files in parallel. Consider this to avoid that larger spooled files are preventing processing of smaller spooled files, which might require a smaller response time.


    • Related Articles

    • SPLF (spooled files)

      Spooled files (splf) is one of the file types/payloads, that can be handled by the InterFormNG2 workflow. This is only relevant to the IBM i platform. The support for spooled file is covered here.

    • Spooled files in the designer

      You can process spooled files in InterFormNG2, if you have installed InterFormNG2 on the IBM i platform. The spooled file actions related to the designer are: •How to load a spooled file in the designer. •How to map spooled file data in the designer. ...

    • Handling large spooled files in parallel

      The processing of spooled files on an output queue is single threaded, so if you are processing larger spooled files (that takes longer to process and print), then smaller spooled files on the same output queue might wait for the processing of a ...

    • Splitting input files

      InterFormNG2 is able to split up these types of files: 1.Spooled files 2.XML files If the input file is of any other type e.g. CSV or JSON, then you need to convert the input file into XML (with CSV to XML or JSON to XML) before you can split it up. ...

    • Spooled files and duplex

      If you want to combine spooled file processing with duplex, then you first need to consider which duplex option, that you want to implement. In the scenarios below it is assumed, that you want to process the input spooled file in the usual way: That ...