By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

How can I know to which column a null value has been assigned? (SQL0407N)

P: n/a

For some reason SQL0407N error messages never reveal the name of the column
to which a NULL value has been assigned. Here is an example:

SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=2,
TABLEID=10, COLNO=11" is not allowed

How can I find out the name of the column?

With best regards
Pekka

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Pekka Henttonen wrote:

For some reason SQL0407N error messages never reveal the name of the
column to which a NULL value has been assigned. Here is an example:

SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=2,
TABLEID=10, COLNO=11" is not allowed

How can I find out the name of the column?


SELECT tabschema, tabname, colname
FROM syscat.columns
WHERE colno = ... AND
( tabschema, tabname ) IN
( SELECT tabschem, tabname
FROM syscat.tables
WHERE tbspaceid = ... AND
tableid = ... )
--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.