CPY-00007
Select list has fewer columns than destination table
Cause
On an APPEND operation or INSERT (when the table exists), the number of columns in the SELECT command is less than the number of columns in the destination table.
Action
Re-specify the COPY command, making sure that the number of columns being selected agrees with the number in the destination table.