• Print |
• E-mail  |
• Bookmark

When you attempt to use PROC DBLOAD to load a DB2 table or when you
attempt to use PROC DBLOAD APPEND to append to an existing DB2 table
using SAS V8 and you specify a schema different from the default, the
table may be loaded into the default schema instead of the specified
schema OR you may receive the error message

  ERROR: DB2 table already exists

For example:

proc dbload dbms=db2_unix data=test;
user=user1;
using=using1;
table=user2.table;
load;
run;

The log indicates that the user2.table is created, but when you try to
access the table under user2, it is not there. However, the table is
created as user1.table.

To work around this problem, use the LIBNAME Access engine to create
DB2 tables.

To resolve this problem, upgrade to SAS V8.2, or, in V8.1, download the
following file from ftp.sas.com using a BINARY transfer:

   /techsup/download/maint/access/db2/AIXR/8.10/sasdbudb.dbload_schema

Place the file in the !SASROOT/sasexe directory, rename it to
"sasdbudb" and be sure the file has READ and EXECUTE permissions
(i.e chmod 755 sasdbudb).

Operating System and Release Information