Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile
• My SAS

• Print  |
• Feedback  |
• Share

  • E-mail
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

Performing a COUNT(XXX) or COUNT(distinct XXX) on a column that was
renamed from its original name when the SAS view was created may degrade
performance.

Rather than passing the function to DB2, SAS removes it and processes
the function itself.  This results in all rows being retrieved from
DB2 increasing the time it takes for the query to run.

An example that would cause this situation to occur is as follows:

   libname db2lib db2 authid=sasdemo ssid=db2p;

   proc sql;
   create view test as
   select employeenumber as empid
   from db2lib.employees;

   select count(distinct empid) as empcount
   from test;
   quit;


A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#009529

For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#009529

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at:

A fix for Release 8.2 (TS2M0) with Asian Language Support (DBCS) for this issue is available at: