COPY FROM | INTO PROGRAM
Valid in: ESQL
The COPY FROM | INTO PROGRAM statement copies data from or to memory, providing the quickest way to bulk-load data. This statement differs from the COPY statement in that the COPY FROM | INTO PROGRAM statement declares a user-coded handler in the COPY statement WITH clause.
• In a COPY INTO PROGRAM statement, COPY calls the user handler passing each row it receives from the DBMS.
• In a COPY FROM PROGRAM statement, COPY calls the user handler for the next row of data until the handler indicates that there are no more rows.