Usage Note 17150: Using PROC DB2UTIL to update a NOT NULL character column in DB2 to a '.'
value produces an SQL error -407
When PROC DB2UTIL is used to update a DB2 table having character columns
defined as NOT NULL, attempting to load a period ('.') value into such a
column produces the following error:
DSNT408I SQLCODE = -407, ERROR: AN UPDATE, INSERT, OR SET VALUE IS
NULL, BUT THE OBJECT COLUMN column_name CANNOT CONTAIN NULL VALUES
The DB2UTIL code examines the character value after stripping trailing
blanks, and compares it to a '.'. If the values are equal it inserts a
null into the database column. This value is rejected by DB2.
There is no circumvention for this except to use a different character
value in place of the period. Since this procedure is running in SAS V6
compatibility mode no fix will be provided.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.1 TS1M3 SP3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | low |
| Topic: | SAS Reference ==> Procedures ==> DB2UTIL
|
| Date Modified: | 2006-03-02 11:33:56 |
| Date Created: | 2006-03-02 11:20:38 |
