Problem Note 50215: The Teradata Loader transformation generates code that will not run in the database
The Teradata Loader transformation generates code that will not be passed to the database for execution. The transformation uses the data set option DBCREATE_TABLE_OPTS to specify DBMS-specific clauses when the Teradata table is created in the database. For example, if your source table contains a primary index, the Teradata Loader transformation will use the DBCREATE_TABLE_OPTS data set option to generate the DBMS-specific clause to build a primary index when the target table is created. The Teradata Loader transformation also uses the option during the insertion of new records into the target table. Because the option is valid only when processing statements that create a table, the generated statements are not passed directly to the database for processing. With the SAS® DBMS tracing options invoked, you will see the following message in the SAS log:
SAS_SQL: Cannot handle dataset options.
SAS_SQL: Unable to convert the query to a DBMS specific SQL statement due to an
error.
The only workaround for the issue is to modify the code that is generated by the Teradata Loader transformation to remove the DBCREATE_TABLE_OPTS data set option from the INSERT statement.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Data Integration Studio | Windows 7 Enterprise x64 | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Windows 7 Home Premium 32 bit | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Windows 7 Home Premium x64 | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Windows 7 Professional 32 bit | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Windows 7 Professional x64 | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Windows 7 Ultimate 32 bit | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Windows 7 Ultimate x64 | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Windows Vista | 4.6 | | 9.3 TS1M2 | |
Windows Vista for x64 | 4.6 | | 9.3 TS1M2 | |
Windows 7 Enterprise 32 bit | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft Windows XP Professional | 4.6 | | 9.3 TS1M2 | |
Microsoft Windows Server 2012 Std | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft Windows Server 2012 R2 Std | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft Windows Server 2012 R2 Datacenter | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft Windows Server 2012 Datacenter | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft Windows Server 2008 for x64 | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft Windows Server 2008 R2 | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft Windows Server 2008 | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft Windows Server 2003 for x64 | 4.6 | | 9.3 TS1M2 | |
Microsoft Windows Server 2003 Standard Edition | 4.6 | | 9.3 TS1M2 | |
Microsoft Windows Server 2003 Enterprise Edition | 4.6 | | 9.3 TS1M2 | |
Microsoft Windows Server 2003 Datacenter Edition | 4.6 | | 9.3 TS1M2 | |
Microsoft Windows 8.1 Pro 32-bit | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft Windows 8.1 Pro | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft Windows 8.1 Enterprise x64 | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft Windows 8.1 Enterprise 32-bit | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft Windows 8 Pro x64 | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft Windows 8 Pro 32-bit | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft Windows 8 Enterprise x64 | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft Windows 8 Enterprise 32-bit | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
Microsoft® Windows® for x64 | 4.6 | 4.8 | 9.3 TS1M2 | 9.4 TS1M1 |
*
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 Teradata Loader transformation generates an INSERT query using the DBCREATE_TABLE_OPTS data set option, which cannot be passed to the database for execution. Execution of the query is handled in SAS®.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2013-08-07 10:34:37 |
Date Created: | 2013-06-18 10:01:29 |