Problem Note 6013: SUBSET WHERE used in ADABAS access descriptor returns zero rows
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
| SAS System | SAS/ACCESS Interface to Adabas | z/OS | 8 TS M0 | 9.1 TS1M0 |
*
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: | SAS Reference ==> Procedures ==> ACCESS
|
| Date Modified: | 2002-11-20 12:01:06 |
| Date Created: | 2001-10-08 12:09:52 |
