Problem Note 14474: Wrong number of records returned when ::ForeignKeys syntax is submitted
to DB2
When the ::ForeignKeys special syntax is used to extract the list of
columns that are part of a foreign keys, the DB2 engine returns the
wrong number of records. This occurs due to an error in the SELECT
statement that retrieves the requested information.
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#014474
For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#014474
Operating System and Release Information
SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9 TS M0 | 9.1 TS1M3 SP2 |
*
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: | alert |
Topic: | Data Management ==> Data Sources ==> External Databases ==> DB2 SAS Reference ==> LIBNAME Engines
|
Date Modified: | 2005-04-27 14:49:09 |
Date Created: | 2005-02-03 10:44:17 |