If you want to import a series of tables in parallel, to speed up your import process, the PARALLEL statement can be used. This is best used with multiple import statements. While other statements can be put in the parallel block , ideally each statement should be self-contained, and not depend on the sequence of execution and any other statement in the parallel block.
Syntax:
DO PARALLEL Statement 1 …… Statement NEND PARALLEL
Example:
Imports 3 tables in Parallel
DO PARALLEL
IMPORT TABLE1 = A1.TABLE1
IMPORT TABLE2 = A1.TABLE2
IMPORT TABLE3 = A1.TABLE3
END PARALLEL
Overview
Content Tools