Problem Note 54811: 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:
- Remove the quotation marks from the database name.
- Use the SCHEMA= option in place of the DATABASE= option.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Teradata | Microsoft® Windows® for x64 | 9.3 TS1M2 | |
| Microsoft Windows 8 Enterprise 32-bit | 9.3 TS1M2 | |
| Microsoft Windows 8 Enterprise x64 | 9.3 TS1M2 | |
| Microsoft Windows 8 Pro 32-bit | 9.3 TS1M2 | |
| Microsoft Windows 8 Pro x64 | 9.3 TS1M2 | |
| Microsoft Windows 8.1 Enterprise 32-bit | 9.3 TS1M2 | |
| Microsoft Windows 8.1 Enterprise x64 | 9.3 TS1M2 | |
| Microsoft Windows 8.1 Pro | 9.3 TS1M2 | |
| Microsoft Windows 8.1 Pro 32-bit | 9.3 TS1M2 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M2 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M2 | |
| Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M2 | |
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M2 | |
| Microsoft Windows Server 2008 | 9.3 TS1M2 | |
| Microsoft Windows Server 2008 R2 | 9.3 TS1M2 | |
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M2 | |
| Microsoft Windows Server 2012 Datacenter | 9.3 TS1M2 | |
| Microsoft Windows Server 2012 R2 Datacenter | 9.3 TS1M2 | |
| Microsoft Windows Server 2012 R2 Std | 9.3 TS1M2 | |
| Microsoft Windows Server 2012 Std | 9.3 TS1M2 | |
| Microsoft Windows XP Professional | 9.3 TS1M2 | |
| Windows 7 Enterprise 32 bit | 9.3 TS1M2 | |
| Windows 7 Enterprise x64 | 9.3 TS1M2 | |
| Windows 7 Home Premium 32 bit | 9.3 TS1M2 | |
| Windows 7 Home Premium x64 | 9.3 TS1M2 | |
| Windows 7 Professional 32 bit | 9.3 TS1M2 | |
| Windows 7 Professional x64 | 9.3 TS1M2 | |
| Windows 7 Ultimate 32 bit | 9.3 TS1M2 | |
| Windows 7 Ultimate x64 | 9.3 TS1M2 | |
| Windows Vista | 9.3 TS1M2 | |
| Windows Vista for x64 | 9.3 TS1M2 | |
| 64-bit Enabled AIX | 9.3 TS1M2 | |
| 64-bit Enabled HP-UX | 9.3 TS1M2 | |
| 64-bit Enabled Solaris | 9.3 TS1M2 | |
| HP-UX IPF | 9.3 TS1M2 | |
| Linux | 9.3 TS1M2 | |
| Linux for x64 | 9.3 TS1M2 | |
| Solaris for x64 | 9.3 TS1M2 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
The problem occurs when the database name is quoted.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2015-01-12 11:22:28 |
| Date Created: | 2014-12-09 13:19:10 |