Problem Note 8460: SAS/ACCESS Interface to CA-OpenIngres does not support MULTINATIONAL4
dates
The following error message may be issued when attempting to use the SAS
SQL procedure in explicit mode, the SAS/ACCESS Interface to
CA-OpenIngres software, and specifying a date in a MULTINATIONAL4 date
format.
ERROR: Error opening cursor. INGRES error is E_US10D0 15 is not a valid
month for a date column.
The Ingres database software recognizes date formats via the setting of
the environment variable II_DATE_FORMAT. For SAS/ACCESS Interface to
CA-OpenIngres to process dates returned by the Ingres database
server, a consistent format is required.
Currently, SAS/ACCESS Interface to CA-OpenIngres supports only the
FINLAND date output format (YYYY-MM-DD). The FINLAND date format does
not recognize dates in MULTINATIONAL4 date format (MM/DD/YYYY). This can
be a problem when using the SAS SQL procedure in explicit mode and
specifying a date using a format incompatible with the FINLAND date
format.
In this case, the query is passed straight to the Ingres software.
Since SAS/ACCESS Interface to CA-OpenIngres sets the date format to be
FINLAND, specifying the date format in anything but a FINLAND-compatible
date format can result in the date being rejected by the Ingres
software.
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#008460
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to CA-OpenIngres | HP-UX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled Solaris | 8.2 TS2M0 | 8.2 TS2M0 |
| Solaris | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled AIX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled HP-UX | 8.2 TS2M0 | 8.2 TS2M0 |
| AIX | 8.2 TS2M0 | 8.2 TS2M0 |
| Tru64 UNIX | 8.2 TS2M0 | 8.2 TS2M0 |
*
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.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Ingres SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2002-09-19 09:15:26 |
| Date Created: | 2002-09-16 11:11:41 |