What is the difference between the DIRECT and CALL DIRECT statements?
DIRECT is invoked immediately at statement compile time. CALL DIRECT is invoked at run-time. Both commands allow execution of SQL statements. Common uses include table creation, truncation, the adding of indices after a load, and execution of stored procedures. Tip : you can use DIRECT within a script to set up your environment – to create and populate tables, for example – before the run-time logic is executed.
