SAP Knowledge Base Article - Preview

1944925 - PowerBuilder 12.5: DB2 INSERT to nullable column with default results in Assignment of a NULL value to a NOT NULL column error

Symptom

Upgraded the DB2 database from ZOS to LUW.

Performing an INSERT on a table that has a column that allows nulls and is defined WITH DEFAULT 'n' results in the following error:

(4515440): *** ERROR -407 ***(rc -1) : SQLSTATE = 23502
[IBM][CLI Driver][DB2/NT64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=60, TABLEID=2177, COLNO=5" is not allowed. SQLSTATE=23502


Read more...

Environment

SAP Sybase PowerBuilder

Product

SAP PowerBuilder 12.5

Keywords

dbparm, pb , KBA , BC-SYB-PB , PowerBuilder , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.