Usage Note 61235: Conflicting data type errors occur when using Teradata TPT FastExport
Conflicting data type errors can occur when using Teradata FastExport with count functions and a group variable. The following example shows the error using a Teradata table:
proc sql;
connect to teradata as tera1 (user=my-user_ID password=my-password server=my-server tpt=yes fastexport=yes);
create table name as
select * from connection to tera1
(select name, count(*) from myclass group by name);
ERROR: Teradata connection: TPT FastExport: TPTAPI_INFRA: API307: Error: Conflicting data
type for column(2) - "Count(*)". Source column's data type is (DECIMAL) Target column's
data type is (INTEGER)..
The problem occurs because of a difference between ANSI and TERADATA modes and the default data type for a count. ANSI SQL mode returns a count as a DECIMAL while Teradata SQL returns a count as an Integer.
To circumvent the problem, do one of the following:
select name, cast(count(*) as integer)
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Teradata | Microsoft® Windows® for x64 | 9.4 | | 9.4 TS1M0 | |
| Microsoft Windows 8 Enterprise x64 | 9.4 | | 9.4 TS1M0 | |
| Microsoft Windows 8 Pro x64 | 9.4 | | 9.4 TS1M0 | |
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 | | 9.4 TS1M0 | |
| Microsoft Windows 8.1 Enterprise x64 | 9.4 | | 9.4 TS1M0 | |
| Microsoft Windows 8.1 Pro 32-bit | 9.4 | | 9.4 TS1M0 | |
| Microsoft Windows 8.1 Pro x64 | 9.4 | | 9.4 TS1M0 | |
| Microsoft Windows 10 | 9.4 | | 9.4 TS1M0 | |
| Microsoft Windows Server 2008 R2 | 9.4 | | 9.4 TS1M0 | |
| Microsoft Windows Server 2008 for x64 | 9.4 | | 9.4 TS1M0 | |
| Microsoft Windows Server 2012 Datacenter | 9.4 | | 9.4 TS1M0 | |
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 | | 9.4 TS1M0 | |
| Microsoft Windows Server 2012 R2 Std | 9.4 | | 9.4 TS1M0 | |
| Microsoft Windows Server 2012 Std | 9.4 | | 9.4 TS1M0 | |
| Windows 7 Enterprise x64 | 9.4 | | 9.4 TS1M0 | |
| Windows 7 Professional x64 | 9.4 | | 9.4 TS1M0 | |
| 64-bit Enabled AIX | 9.4 | | 9.4 TS1M0 | |
| 64-bit Enabled Solaris | 9.4 | | 9.4 TS1M0 | |
| HP-UX IPF | 9.4 | | 9.4 TS1M0 | |
| Linux for x64 | 9.4 | | 9.4 TS1M0 | |
| Solaris for x64 | 9.4 | | 9.4 TS1M0 | |
*
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.
When using Teradata FastExport, you might receive conflicting data type errors. To circumvent the problem, cast the variable to an existing type.
| Date Modified: | 2017-11-07 14:05:17 |
| Date Created: | 2017-10-12 12:23:18 |