DO PARALLEL …. END PARALLEL

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 N 
END PARALLEL

Example:

/* Imports 3 tables in Parallel */
DO PARALLEL
IMPORT TABLE1 = A1.TABLE1
IMPORT TABLE2 = A1.TABLE2
IMPORT TABLE3 = A1.TABLE3
END PARALLEL