Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  SQL0407 Null values not allowed in column or variable

    Posted 10/18/22 09:46 AM
    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


  • 2.  RE: SQL0407 Null values not allowed in column or variable

    Posted 10/19/22 01:29 AM
    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
    ------------------------------



Related Content