Problem Note 2782: Using the dbkey= option results in 0 rows being selected from a Informix
table
When using the dbkey= option to query Informix XPS servers (8.21,8.23)
from an HPUX, AIXR, or Compaq Tru64 client, 0 rows are selected when in
fact there are matches. The problem appears to be with host variable
substitution for the WHERE clauses, which is what SAS uses when the
dbkey= option is specified.
In particular, if a nullable column is used, then the correct number of
matches are returned. However, if a non-nullable column is used then
zero rows being returned.
Currently, the workaround is to set the Informix UNIX environment
variable DELIMIDENT. The environment variable does not take a
parameter.
export DELIMIDENT
or
setenv DELIMIDENT
The DELIMIDENT environment variable specifies that strings set off by
double quotes are delimited identifiers. Because of this, it may not
be feasible to have it set all the time. For those instances where
it can't be set all the time, SAS can be wrapped with a UNIX shell
script that sets DELIMIDENT before SAS is invoked, then unsets it when
SAS is terminated.
In some situations, setting DELIMIDENT may not circumvent this problem.
Therefdre, applying the following HOTFIX should resolve this problem.
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#002782
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to Informix | Tru64 UNIX | 8 TS M0 | 8.2 TS2M0 |
| 64-bit Enabled AIX | 8 TS M0 | 8.2 TS2M0 |
| 64-bit Enabled HP-UX | 8 TS M0 | 8.2 TS2M0 |
| AIX | 8 TS M0 | 8.2 TS2M0 |
| HP-UX | 8 TS M0 | 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: | medium |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Informix
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2002-08-07 11:21:19 |
| Date Created: | 2000-06-06 13:53:52 |
