Problem Note 38705: SAS® Enterprise Guide® tasks do not take advantage of in-database processing
SAS Enterprise Guide tasks do not take advantage of in-database processing because a SAS view is created during the processing of the task. Although the view is created for SAS data set optimization, the view is created whether you are accessing a SAS data set or a database table. Therefore, the view prevents the task code from being sent directly to the database.
A circumvention is to execute the code manually from the SAS Enterprise Guide code node instead of using the task.
Select the Hot Fix tab in this note to access the hot fix for this issue.
After applying the hot fix (A53005), you must modify the SEGuide.exe.config file as described next. The default location for this file is C:\program files\SAS\EnterpriseGuide\4.2
.
In the SEGuide.exe.config file, add the following key:
<appSettings>
<add key="SupportInDbSyntax" value="true" />
</appSettings>
|
Here is a sample of a complete file:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="microsoft.web.services3" type="Microsoft.Web.Services3.Configuration.WebServicesConfiguration,
Microsoft.Web.Services3, Version=3.0.0.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35" />
</configSections>
<microsoft.web.services3>
<policy fileName="wse3policyCache.config" />
</microsoft.web.services3>
<appSettings>
<add key="SupportInDbSyntax" value="true" />
</appSettings>
</configuration>
|
Operating System and Release Information
SAS System | SAS Enterprise Guide | Microsoft Windows Server 2003 Enterprise Edition | 4.22 | 4.3 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Standard Edition | 4.22 | 4.3 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2008 | 4.22 | 4.3 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows XP Professional | 4.22 | 4.3 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Datacenter Edition | 4.22 | 4.3 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft® Windows® for x64 | 4.22 | 4.3 | 9.2 TS2M2 | 9.2 TS2M3 |
Windows 7 Enterprise 32 bit | 4.22 | 4.3 | 9.2 TS2M2 | 9.2 TS2M3 |
Windows 7 Enterprise x64 | 4.22 | 4.3 | 9.2 TS2M2 | 9.2 TS2M3 |
Windows 7 Home Premium 32 bit | 4.22 | 4.3 | 9.2 TS2M2 | 9.2 TS2M3 |
Windows 7 Home Premium x64 | 4.22 | 4.3 | 9.2 TS2M2 | 9.2 TS2M3 |
Windows 7 Professional 32 bit | 4.22 | 4.3 | 9.2 TS2M2 | 9.2 TS2M3 |
Windows 7 Professional x64 | 4.22 | 4.3 | 9.2 TS2M2 | 9.2 TS2M3 |
Windows 7 Ultimate 32 bit | 4.22 | 4.3 | 9.2 TS2M2 | 9.2 TS2M3 |
Windows 7 Ultimate x64 | 4.22 | 4.3 | 9.2 TS2M2 | 9.2 TS2M3 |
Windows Vista | 4.22 | 4.3 | 9.2 TS2M2 | 9.2 TS2M3 |
*
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: | 2010-02-17 11:24:59 |
Date Created: | 2010-02-11 14:35:50 |