MAPTO clause in PROC DB2UTIL requires all columns of DB2 table to be listed


The MAPTO statement of the DB2UTIL procedure requires that all columns of a DB2 table be mapped to corresponding SAS variables when using FUNCTION=INSERT. The following error message is received when all columns are not mapped to SAS variables:

ERROR: Input map and input data do not match, procedure terminated.

To circumvent the problem, include all DB2 column names and a corresponding SAS variable name on the MAPTO statement.