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 How to condition the workflow on spooled file attributes ...

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

    • Database SQL update

      The advanced, utilities workflow component, Database SQL update can be used in order to update or insert data in a table in a database. Enabling custom SQL Custom SQL needs to be enabled in the global System settings. It is divided into two sections: ...