Problem Note 6469: Using NULLS statement in PROC DBLOAD to define a DB2 column as NOT NULL
WITH DEFAULT does not work
In Version 6 of the SAS System on MVS, you could define a DB2 column as
NOT NULL WITH DEFAULT by specifying the NULLS statement. Currently the
statement does not behave in the same manner in Version 8 of SAS. The
column is defined as accepting nulls. This may affect what is passed to
the DB2 DBMS during inserts and updates.
In Version 6, creating the table SASDEMO.TEST(containing one variable)
would look like the following:
CREATE TABLE "SASDEMO"."TEST" ( "X" FLOAT NOT NULL WITH DEFAULT)
In Version 8, the same code would generate a different query.
CREATE TABLE "SASDEMO"."TEST" ( "X" FLOAT)
The current workaround is to first create the table and then
subsequently use an alternate method to load the data (proc append, proc
dbload with append option, etc).
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#006469
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 8 TS M0 | 9 TS M0 |
*
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: | Problem Note |
| Priority: | medium |
| Topic: | SAS Reference ==> Procedures ==> DBLOAD
|
| Date Modified: | 2002-04-22 16:07:28 |
| Date Created: | 2001-12-11 14:09:51 |
