Example 2

Load the temporary table TEMPEMP with data from table EMP.

EXEC SQL

INSERT INTO SMITH.TEMPEMP
SELECT _
FROM EMP

END-EXEC