Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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

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