Once your source table data are available in external files, IRI's CoSort product gives you the ability to leverage the power of the file system, allowing you to perform and/or combine data:

CoSort uses a powerful 4GL program called SortCL to map fields to one or more load, BI, and other hand-off targets. Schema changes, new views, different query orders, and privacy protections are now possible in parallel, single-pass operations that do all of the above. Create new tables as needed, and load files faster pre-sorted on the longest index column (primary key).