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

    • Spooled file support

      InterFormNG2 is able to process spooled files, if you install InterFormNG2 on the IBM i platform. Please notice, that spooled file support, as well as Spool2XML, are modules for InterFormNG2, that are purchased separately. You can also use the ...

    • Enrich spooled file from database

      It is possible to change the contents of a spooled file (as known on the IBM i platform) and to add data from an external database with the advanced special workflow component: Enrich spooled file from database. You can also add data with 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 ...