Ever run DB2 IMPORT and get a super helpful error like…
SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=7,
TABLEID=265, COLNO=2" is not allowed. SQLSTATE=23502
SQL3185W The previous error occurred while processing data from row "126" of
the input file.
After you calm down from wanting to smack a DB2 developer in the face, remember the syscat tables and run this SQL to find out the table and column giving you grief…
select *
from syscat.columns c
inner join syscat.tables t
on c.TABSCHEMA = t.TABSCHEMA
and c.TABNAME = t.TABNAME
where c.COLNO = 2
and t.TABLEID = 265
and t.TBSPACEID = 7
Please remember to subscribe to the newsletter to stay up to date!You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...