Usage Note 16359: An error occurs when you use the SCHEMA= option in PROC SQL pass-through code that accesses DB2 with SAS® 9.2
The following error occurs when you use the SCHEMA= option in the SQL procedure's CONNECT statement:
ERROR: Invalid option name schema.
This error happens in PROC SQL code that is using pass-through processing and that accesses DB2 with SAS 9.2. The same code runs without error in SAS® 8 and SAS® 9.1.3.
The SCHEMA= option has never been a valid option with PROC SQL pass-through code. In
SAS 8 and SAS 9.1.3, the software simply ignored the SCHEMA= option.
In SAS 9.2, the code catches the invalid parameter, thus causing the error message to be written to the log.
To work around the issue, do one of the following:
- Remove the SCHEMA= option from the CONNECT statement.
-
- Connect to your database with a LIBNAME statement, where the SCHEMA= option is valid.
See SAS Note 40139 for details about how the SCHEMA= option works with the other SAS/ACCESS® products.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to DB2 | Microsoft Windows XP Professional | 9 TS M0 | |
Microsoft Windows NT Workstation | 9 TS M0 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9 TS M0 | |
Microsoft Windows Server 2003 Standard Edition | 9 TS M0 | |
Microsoft Windows Server 2003 Enterprise Edition | 9 TS M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 9 TS M0 | |
Microsoft Windows 2000 Server | 9 TS M0 | |
Microsoft Windows 2000 Professional | 9 TS M0 | |
Microsoft Windows 2000 Datacenter Server | 9 TS M0 | |
Microsoft Windows 2000 Advanced Server | 9 TS M0 | |
Solaris | 9 TS M0 | |
64-bit Enabled Solaris | 9 TS M0 | |
Linux | 9 TS M0 | |
HP-UX | 9 TS M0 | |
HP-UX IPF | 9 TS M0 | |
64-bit Enabled HP-UX | 9 TS M0 | |
64-bit Enabled AIX | 9 TS M0 | |
Tru64 UNIX | 9 TS M0 | |
AIX | 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: | Usage Note |
Priority: | |
Topic: | SAS Reference ==> Procedures ==> ACCESS
|
Date Modified: | 2005-11-04 14:02:27 |
Date Created: | 2005-10-24 13:18:35 |