When you are using the DBCREATE_TABLE_OPTS= data set option and the DBMSTEMP= LIBNAME option to create a Teradata temporary table, an error message similar to the following might occur:

ERROR: Error attempting to CREATE a DBMS table. 
ERROR: Teradata execute: Syntax error: expected something between the 'ROWS' keyword 
       and the 'primary' keyword.

The errors occur because these options are processed in the wrong order.

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

Operating System and Release Information

A fix for this issue for SAS/ACCESS Interface to Teradata 9.4_M1 is available at:

A fix for this issue for Base SAS 9.4_M1 is available at: