An error message similar to the following might be issued when you attempt to alter a database table, depending on the relational database management system (RDBMS) table that you are attempting to alter when using implicit pass-through processing (via a LIBNAME engine in SAS/ACCESS^® software).

The following example illustrates an SQL procedure that replicates the problem when it accesses the Oracle table:

SAS/ACCESS^®  LIBNAME engines support creating tables as well as reading from and writing to tables, but they do not support table altering.

To alter an RDBMS table, you must use explicit pass-through processing (also known as PROC SQL pass-through), as shown in the following example:

Operating System and Release Information