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

Pekka Henttonen wrote:
[color=blue]
>
> 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?[/color]

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