Background documentation-1200: Too few values Locate this document in the navigation structure

 

Explanation

In an INSERT or UPDATE statement the number of specified values is less than the number of column names which may have been specified implicitly.

User Response

Match the number of specified values in the SQL statement with the number of specified column names. Use a QUERY statement issued on the system table DOMAIN.COLUMNS for an INSERT statement without column name specification to determine the definition of the table being used.