Problem Note 6736: Specifying DBKEY= to reference a composite index can produce one of
several error messages
Specifying DBKEY= to reference a composite index will result in no
records being found. The _IORC_ automatic variable will have a value
that corresponds to the mnemonic _DSENOM. The problem occurs if you are
using DBKEY= in either the SQL procedure or the Data step MODIFY or SET
KEY= statements. There are no problems using DBKEY= where you specify a
simple index.
Another error that may surface is a DB2 -310.
DB2 SQL Error, sqlca->sqlcode=-310
This is result of the same issue. Which one occurs depends on how the
DB2 key variables are defined.
There is no current circumvention.
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#006736
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 8.2 TS2M0 | 9 TS M0 |
*
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 ==> LIBNAME Engines
Data Management ==> Data Sources ==> External Databases ==> DB2
|
| Date Modified: | 2002-04-22 16:10:06 |
| Date Created: | 2002-01-23 15:49:10 |
