15793 - MODE=Teradata does not allow Teradata case insensitive behavior when comparing character strings in the WHERE clause

Problem Note 15793: MODE=Teradata does not allow Teradata case insensitive behavior when comparing character strings in the WHERE clause

When you set MODE=Teradata where only the T in Teradata is capitalized, the default mode of ansi is still in effect. With this setting, when you subset your data based on a text field, the character comparison will be case sensitive. However, if you set MODE=teradata(teradata in all lowercase letters) or MODE=TERADATA(TERADATA in all uppercase), the character comparison will be case-insensitive.

Currently, the only workaround is to specify Teradata in lowercase(teradata) or uppercase(TERADATA).

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS/ACCESS Interface to Teradata	64-bit Enabled HP-UX	9.1 TS1M3	9.1 TS1M3 SP4
		64-bit Enabled Solaris	9.1 TS1M3	9.1 TS1M3 SP4
		Linux	9.1 TS1M3	9.1 TS1M3 SP4
		64-bit Enabled AIX	9.1 TS1M3	9.1 TS1M3 SP4

* 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.

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#015793

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#015793

Type:	Problem Note
Priority:	low
Topic:	Data Management ==> Data Sources ==> External Databases ==> Teradata SAS Reference ==> LIBNAME Engines

Date Modified:	2006-04-14 10:53:47
Date Created:	2005-07-20 11:15:00