Problem Note 44981: Error message "DS2 pgm failed to be preparedUnable to get catalog string" might occur while executing High Performance procedures on Teradata
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
| 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.
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 |
