Run this query against the affected table:
The error message usually names the variable. If not, check the ERP application log or enable DB2 query logging (e.g., db2pd -dynamic or db2mon ). Look for the failing SQL statement. erp0215e
SELECT colname, typename, length, scale, nulls FROM syscat.columns WHERE tabname = 'YOUR_TABLE_NAME'; Match the column’s type/length with the variable your application is providing. Run this query against the affected table: The
If the column is NOT NULL and your variable is null (or missing), provide a default value. provide a default value.
Run this query against the affected table:
The error message usually names the variable. If not, check the ERP application log or enable DB2 query logging (e.g., db2pd -dynamic or db2mon ). Look for the failing SQL statement.
SELECT colname, typename, length, scale, nulls FROM syscat.columns WHERE tabname = 'YOUR_TABLE_NAME'; Match the column’s type/length with the variable your application is providing.
If the column is NOT NULL and your variable is null (or missing), provide a default value.