SQL Statements › INSERT › Processing › Example 3
Load the temporary table TEMPEMP with data from Department E1 from EMP.
EXEC SQL
INSERT INTO SMITH.TEMPEMP
SELECT FROM EMP WHERE WORKDEPT = 'E1'
END-EXEC
