Desktop productivity for business analysts and programmers

Hotfix install 41EG02

Reply
N/A
Posts: 0

Hotfix install 41EG02

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
SAS Employee
Posts: 1

Re: Hotfix install 41EG02

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).
N/A
Posts: 0

Re: Hotfix install 41EG02

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

-Matthew
N/A
Posts: 0

Re: Hotfix install 41EG02

Hi

May I have the SN-019473 ?

Delphine
N/A
Posts: 0

Re: Hotfix install 41EG02

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
Ask a Question
Discussion stats
  • 4 replies
  • 113 views
  • 0 likes
  • 2 in conversation