I've got a script I'm using against a DB2 database, and I'd like it to be able to check that all required values are present prior to trying an INSERT
-- so I'd like to select a list of the not null
columns from the table I'm about to insert into. Since the table definition may change I'd like to do this rather than using a static list so the script won't break if there's a new not null
column added.
Is there a way to get these values from a DB2 query, maybe against syscat
?
VERSIONNUMBER VERSIONTIMESTAMP AUTHID VERSIONBUILDLEVEL
-------------------------------------------------------
10010400 2016-12-03 16:46:01.509317 ADMIN s140509