Add data to spooled files via SQL

Add data to spooled files via SQL

If you want to add data from a database into a spooled file via SQL, then you should consider these options:

  1. Enrich spooled file from database workflow component inside your workflow.
  2. You can also consider to use the ng:databaseLookup function for a spooled file within a transformation. Here you can e.g. transform a spooled file into another spooled file and at the same time add extra data into a new attribute
  3. You can also add the extra SQL data into a spooled file line.
  4. You can even add data into a new, hidden attribute in the spooled file.
  5. After running this in the workflow you can refer to the extra data both in the workflow and in the designer and even save a copy of the changed contents with the To filesystem component.
    • Related Articles

    • 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 Convert a variable CPI spooled file How to condition the ...
    • Merge multiple spooled files

      This article describes one way to merge multiple spooled files together - similar to the function: Output Schedule Control (OSC) in InterForm400. The principle of Output Schedule Control is to wait for many spooled files of various types to arrive on ...
    • Output via remote clients

      This section describes how to use remote clients in the InterFormNG2 workflow. The remote client can be used for these kinds of output in the workflow: Print on remote printers, that are only reachable via the remote client(s) Email via email ...
    • 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. ...
    • 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 ...