• Print |
• E-mail  |
• Bookmark

When referencing an ADABAS superdescriptor column in an access view
SUBSET WHERE statement, where the column is comprised of numeric and
character columns, hexadecimal value(s) should be used.

This is documented on page 94 of the "SAS/ACCESS Interface to ADABAS
Software: Reference, Version 8" manual.  In V8, the SUBSET WHERE
condition passed to ADABAS is not honored resulting in zero rows
returned from the DBMS. There are no errors indicating the SUBSET WHERE
is not processed.  This problem was found in V8, and does not occur in
Release 6.09.

The work around it to use a SAS WHERE clause.

IE:
data new;
 set adb.vname;
where col1 = 'condition';
run;


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#006013

For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#006013

Operating System and Release Information

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

A fix for Release 8.2 (TS2M0) with Asian Language Support (DBCS) for this issue is available at: