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.

    Notice: Help Center Transition Update

    As of January 13, 2025, we are excited to announce that our new Help Center is in the final stages of development. While the Knowledge Base is already accessible, our current JIRA system will continue to manage support tickets during this transition period. For assistance with InterForm Output Management Software, please refer to the Support for InterForm Output Management Software.

    We appreciate your patience and understanding as we work to enhance your support experience. If you have any questions or encounter any issues, please do not hesitate to reach out via the existing support channels.

    Best regards,
    The InterForm Support Team


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

      • 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: 1.Print on remote printers, that are only reachable via the remote client(s) 2.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: ...