Problem Note 48127: Running a Base SAS® procedure on DB2 in a z/OS operating environment might result in an error
Running a Base SAS procedure under z/OS against a DB2 table might result in the following error:
ERROR: Requested function is not supported.
This issue might occur with the following procedures when the system option SQLGENERATION is set to DBMS or DBMS='DB2':
- MEANS
- RANK
- REPORT
- SUMMARY
- TABULATE
In-database processing of the procedures for SAS/ACCESS® Interface to DB2 under z/OS is not supported until the second maintenance release of SAS 9.3 (TS1M2). The table is retrieved from DB2 and the processing is done in SAS as was done previously.
The only workaround is to set the system option SQLGENERATION=NONE.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.3 TS1M0 | 9.3 TS1M2 |
*
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 |
| Date Modified: | 2012-10-26 13:44:29 |
| Date Created: | 2012-10-11 10:04:29 |
