When you try to append data to a DATAllegro table with SAS/ACCESS Interface to ODBC, an error occurs if the table does not already exist. This problem results from a short-coming in the DATAllegro ODBC driver. For example, suppose you assign an ODBC LIBNAME statement using a database source name that has has been created with the DATAllegro ODBC driver. If you subsequently run an APPEND procedure against this library to populate a Datallegro table that does not currently exist, the procedure fails with the following error:

ERROR: CLI prepare error: [DATAllegro][Data Warehouse Appliance
ODBC driver]encountered in
(DSA:generate valid sql statment)  Message Code=DA37001N.
syntax error in dynamic SQL statement. 
Details: Table xxxx does not exist, or is not owned by you.

This problem results from a shortcoming in the DATAllegro ODBC driver. The driver returns an incorrect value from an ODBC call and, as a result, the SAS^® System is not aware that the table does not exist.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: