When you use Teradata Parallel Transport with the SAS/ACCESS® Interface to Teradata product, syntax and Unicode identifier errors occur


When using SAS/ACCESS Interface to Teradata with Teradata Parallel Transport, errors might occur.

If you are using the MultiLoad or FastLoad utilities, you receive this error:

ERROR: Teradata connection: Syntax error, expected something like a name or a Unicode delimited identifier or '(' between the 'FROM' keyword and the string 's' keyword. Correct error and restart as an APPEND process with option TPT_RESTART=YES. Since no checkpoints were taken, if the previous run used FIRSTOBS=n, use the same value in the restar.

If you are using the Teradata FastExport utility, the following error occurs:

ERROR: Teradata connection: TPT FastExport: Syntax error, expected something like a name or a Unicode delimited identifier between the 'DATABASE' keyword and the string 's' keyword.

The problem occurs when the database name in the LIBNAME statement is quoted, as shown in the example below:

libname tera1 teradata server='teradata-server' user='user-ID' password='password' database='database-name';
 
data tera1.testpete01102013(tpt=yes fastload=yes);
set temp1;
run;

To circumvent the issue, do one of the following: