so i'm wanting to do an insert to a table and only specify a couple of key values. the table has each column defined as "NOT NULL", but no default declared. Does this mean I have to specify a value for each one of those on my insert. If I don't it says null value not allowed in column.
my statement
exec sql
insert into loanalt4 (a4loan)
values (:i_loanNumber);
error
Null values not allowed in column or variable A4SEQ.
a4seq in table...
A4_SEQ FOR COLUMN A4SEQ NUMERIC(2,0) NOT NULL,
my statement
exec sql
insert into loanalt4 (a4loan)
values (:i_loanNumber);
error
Null values not allowed in column or variable A4SEQ.
a4seq in table...
A4_SEQ FOR COLUMN A4SEQ NUMERIC(2,0) NOT NULL,
Comment