Usage Note 16359: "ERROR: Invalid option name schema" occurs when using SCHEMA= with PROC SQL Pass-Through code that is accessing DB2 with SAS® 9.2
When using the SCHEMA= parameter in the CONNECT statement in PROC SQL
Pass-Through code that is accessing DB2 with SAS 9.2, you will receive the following error:
ERROR: Invalid option name schema.
The same code runs without error in SAS 8 and SAS 9.1.3.
SCHEMA= was never a valid parameter with PROC SQL Pass-Through code. In
SAS 8 and SAS 9.1.3, SCHEMA= was simply ignored.
In SAS 9.2, the code catches the invalid
parameter, thus causing the ERROR to be written to the log.
To work around the issue, either remove SCHEMA= from the CONNECT
statement, or if possible, use a LIBNAME connection to your database
where SCHEMA= is a valid parameter.
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 | |
| 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 |
