Output batching

The result of each AnySQL run can have a large number of rows, especially the initial load.

The size of the output file can extend the 5 MB limit that is recommended by ION. To reduce the output file size, output batching is used. The size of the output document is evaluated, and if it exceeds the limit, the document is split into multiple parts (batches). Each output batch is identified with batch headers.

See "ION Connecting Considerations - Sending documents in batch" in the Infor ION Development Guide

If a lower limit is required for some specific reason, the configuration is available in the UI. You can define a size limit in a range between 0,1 MB and 5 MB. Together with this limit, you can add additional limitation that is based on the number of rows. Whichever limit is reached first, the output document is split.