Problem Note 38929: "Pass generated SELECT SQL to the DBMS" setting for a library does not remain set after being modified
 |  |  |  |
If you open the Properties for any DBMS library defined in SAS® Management Console and navigate to the Options tab, then click the Advanced Options button and navigate to the Optimization tab, you will see a section at the bottom of the window labeled Pass generated SELECT SQL to the DBMS. If you make certain changes to the settings in this section, these changes are not saved to the SAS® Metadata Repository.
For example, click the radio button for Exceptions to DBMS Processing and move NOWHERE to the selected items side, then click OK to back your way out of the library properties. Right–click on the Library object and choose Display libname. You will see that the DIRECT_SQL option does not appear in the generated LIBNAME statement as it should. Now, navigate back into the Advanced Options Optimization tab, and you will see that the DBMS Processing button is once again selected (and set to Yes) and the NOWHERE setting is gone from the Exceptions to DBMS Processing Selected items.
Another manifestation of this issue occurs when you change the value of DBMS Processing from Yes to NONE and save the changes. This change is saved successfully. However, if you then try to change the value from NONE back to Yes or No, the value always reverts to NONE.
Currently, the only workaround to ensure the library is assigned with the correct value is to mark the library as pre–assigned and add a LIBNAME statement to your server's autoexec file. You can then include the DIRECT_SQL= option on your LIBNAME statement and set it to the value you require.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Management Console | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft Windows XP 64-bit Edition | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft Windows XP Professional | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Windows Vista | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Solaris for x64 | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| 64-bit Enabled Solaris | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| HP-UX IPF | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Linux | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Linux for x64 | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| 64-bit Enabled AIX | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| 64-bit Enabled HP-UX | 9.2_M1 | 9.3_M2 | 9.2 TS2M0 | 9.3 TS1M2 | ||
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Data Management ==> Administration Data Management ==> Data Sources ==> External Databases Data Management ==> Data Sources ==> Metadata |
| Date Modified: | 2012-06-26 14:40:54 |
| Date Created: | 2010-03-04 13:20:37 |