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:

 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:

• Add MODE=TERADATA to your connection string. This string can change how your query is evaluated.

  Connections that open with MODE=TERADATA use Teradata mode rules for all SQL requests that are passed to the Teradata database management system (DBMS). This issue impacts transaction behavior and can cause case insensitivity when processing data.

• Cast the count value as an integer as shown below:

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
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.

Type:	Usage Note
Priority:

Date Modified:	2017-11-07 14:05:17
Date Created:	2017-10-12 12:23:18