The following error messages might be generated when running one of the SAS High Performance Analytic procedures on Teradata:

   ERROR: [Teradata][ODBC Teradata Driver][Teradata Database] DS2 pgm failed to be
          preparedUnable to get catalog string.
   ERROR: The data could not be retrieved from the data source.

The problem might be prevented by installing the hotfix associated with this SAS Note. The hotfix adds four new date and time related functions to the DS2 language as follows:

   as_time      - takes a SAS time double and returns a DS2 time value.
   as_date      - takes a SAS date double and returns a DS2 date value.
   as_timestamp - takes a SAS datetime double and returns a DS2 timestamp value.
   as_double    - takes a DS2 date, time, or timestamp value and returns a
                  SAS date, time, or datetime double.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	Base SAS	Teradata on Linux	9.3		9.3 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.

---

A fix for this issue for In-Database for Teradata on Linux is available at:

http://ftp.sas.com/techsup/download/hotfix/HF2/F96.html#44981

---

Four new functions (as_date, as_time, as_timestamp, and as_double) have been added to alleviate the error: "ERROR: [Teradata][ODBC Teradata Driver][Teradata Database] DS2 pgm failed to be preparedUnable to get catalog string".

Type:	Problem Note
Priority:	high

Date Modified:	2011-12-20 14:58:10
Date Created:	2011-11-30 14:15:38