![]() | ![]() | ![]() | ![]() |
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.
Product Family | Product | System | SAS Release | |
Reported | Fixed* | |||
SAS System | SAS/ACCESS Interface to Teradata | Microsoft 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 System | SAS/ACCESS Interface to Sybase | Microsoft 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 System | SAS/ACCESS Interface to SAP BW | Microsoft 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 System | SAS/ACCESS Interface to R/3 | Microsoft 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 System | SAS/ACCESS Interface to PeopleSoft | Microsoft 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 System | SAS/ACCESS Interface to Oracle | Microsoft 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 System | SAS/ACCESS Interface to Oracle Rdb | Microsoft 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 System | SAS/ACCESS Interface to PC Files | Microsoft 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 System | SAS/ACCESS Interface to MySQL | Microsoft 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 System | SAS/ACCESS Interface to ODBC | Microsoft 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 System | SAS/ACCESS Interface to OLE DB | Microsoft 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 System | SAS/ACCESS Interface to DB2 | Microsoft 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 System | SAS/ACCESS Interface to DB2 Server for VM | Microsoft 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 System | SAS/ACCESS Interface to IMS-DL/I | Microsoft 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 System | SAS/ACCESS Interface to Informix | Microsoft 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 System | SAS/ACCESS Interface to CA-OpenIngres | Microsoft 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 System | SAS/ACCESS Interface to CA-Datacom/DB | Microsoft 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 System | SAS/ACCESS Interface to CA-IDMS | Microsoft 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 System | SAS/ACCESS Interface to Adabas | Microsoft 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 System | SAS/ACCESS Interface to Baan | Microsoft 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 |