SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 14959: An error occurs if a database table already exists and you reference it in a DATA step or in an SQL or FEDSQL procedure's CREATE TABLE statement

DetailsAboutRate It

Referencing a database table in a DATA step or in a PROC SQL or PROC FEDSQL CREATE TABLE statement might result in this error:

ERROR: The XXXXXX table YYYYY has been opened for OUTPUT. This table already exists,
or there is a name conflict with an existing object. This table will not be replaced.  
This engine does not support the REPLACE option.

In this message, XXXXXX represents the database engine name and YYYYY represents the table name.

The error occurs if the database table that you reference already exists.

If you attempt to append rows to the database table that is referenced in the error, use the APPEND procedure or the PROC SQL INSERT statement. Both PROC APPEND and PROC SQL support the BULKLOAD= option, provided that the SAS/ACCESS® engine for the particular database supports bulk loading.

To prevent the error altogether, drop the database table before you attempt to re-create the table.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to TeradataMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to SybaseMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to SAP BWMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to R/3Microsoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to PeopleSoftMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
OpenVMS Alpha
CMS
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to OracleMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to Oracle RdbMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to PC FilesMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to MySQLMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to ODBCMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to OLE DBMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to DB2Microsoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to DB2 Server for VMMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to IMS-DL/IMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to InformixMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to CA-OpenIngresMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to CA-Datacom/DBMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to CA-IDMSMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to AdabasMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
SAS SystemSAS/ACCESS Interface to BaanMicrosoft Windows XP Professional
Microsoft Windows NT Workstation
Microsoft Windows 95/98
Windows Millennium Edition (Me)
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Advanced Server
OpenVMS VAX
Solaris
64-bit Enabled Solaris
IRIX
OS/2
z/OS
Linux
ABI+ for Intel Architecture
HP-UX
64-bit Enabled HP-UX
CMS
OpenVMS Alpha
64-bit Enabled AIX
Tru64 UNIX
AIX
* 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.