Hi!
Without seeing the SQL it is tough but I would hazard a guess you are doing an INSERT and not giving all column names/values. Then the "missing" ones get the NULL value and if they are defined as NOT NULL then you get this exception. That's how it is on z/OS anyways...
------------------------------
Roy Boxwell
------------------------------
Original Message:
Sent: Mon October 17, 2022 08:05 PM
From: Keerthivasan K
Subject: SQL0407 Null values not allowed in column or variable
SQL0407 Null values not allowed in column or variable, Even when the values are not null the exception is thrown. Is there any way that a statement gets skipped during exception.
------------------------------
Keerthivasan K
------------------------------
#Db2