Re: Hotfix install 41EG02

deleted_user · Posted 02-01-2007 08:20 AM

I am about to test the Hotfix install of 41EG02 for Enterprise Guide 4. Assuming all goes well, I will recommending it be included in our colleges PC ghost. Has anyone had any problems with this Hotfix or the previous one 41EG01?

I'm running EG under Win XP, with SAS 9.1.3.
I use EG to work on a SAS BI installation on
Win 2003 Enterprise HP servers.

- Matthew Seeman
Broward Community College
gseeman@broward.edu

xelat_sas · Posted 02-02-2007 05:26 PM

This hotfix is considered to be an ALERT hotfix as it has fixed a lot of issues.

Having said that, just be careful if you have INNER JOIN and WHERE clause with OR operator in a query. After you applied the hotfix, the generated SQL will have missing parentheses in the OR operator and make the result unexpected. This is because of the change to SN-019152. The current work-around is to separate the Join and WHERE queries by creating multiple queries. See SN-019473 (currently pending, should be releasing soon).

deleted_user · Posted 03-26-2007 04:16 PM

FYI: This issue has been addressed in Hotfix 41EG03 released in March 07

-Matthew

deleted_user · Posted 06-13-2008 08:33 AM

Hi

May I have the SN-019473 ?

Delphine

deleted_user · Posted 06-13-2008 08:54 AM

Hi
One more question about Inner join in Proc SQL.

We do have the Hotfix install 41EG06 but we still have problems with this kind of join.
For example one query with the inner join has a 3 hours response time and the same result with a left join has a 7 minutes response time ...

Have you ever had this problem, I mean an inner join longer that an outer join ?

Delphine

Hotfix install 41EG02