• Print |
• E-mail  |
• Bookmark

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

A fix for Release 8.2 (TS2M0) for this issue is available at: