PROC DB2UTIL might produce the following error messages:

ERROR: In map specification for sasname: sas-variable-name ERROR: Nothing selected or mapped, procedure terminated.

This occurs when the DB2 variable that is being mapped to the sas-variable-name does not exist in the DB2 table and not all columns of that DB2 table appear in the MAPTO clause. If all columns appear, only the first error message is displayed and the insert may still occur.

To prevent the errors, update the MAPTO with the appropriate DB2 column name.