Problem Note 14804: Passing the SAS function STRIP to Oracle as their TRIM function improves
performance
Passing down the SAS function STRIP to the Oracle database as Oracle's
TRIM function causes a performance enhancement. To obtain the benefit
of this performance enhancement, SAS will now pass it's STRIP function
to the database to process. However, here is a slight incompatibility
between these functions when the argument passed in is '', ' ' or any
blank padded string and the "=" operator is used. SAS evaluates
STRIP(' ')='', STRIP(' ')=' ' and STRIP(' ') IS NULL
as TRUE whereas, Oracle only evaluates STRIP(' ') IS NULL as
TRUE and the other ones as FALSE. Therefore, try to avoid using "="
comparisons but instead use IS NULL.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Oracle | Microsoft Windows XP Professional | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows NT Workstation | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows 2000 Server | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows 2000 Professional | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
64-bit Enabled Solaris | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
z/OS | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
64-bit Enabled HP-UX | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Linux | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
HP-UX IPF | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
OpenVMS Alpha | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
64-bit Enabled AIX | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
Tru64 UNIX | 9.1 TS1M0 | 9.1 TS1M3 SP2 |
*
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 |
Topic: | SAS Reference ==> LIBNAME Engines Data Management ==> Data Sources ==> External Databases ==> Oracle
|
Date Modified: | 2005-07-14 14:03:48 |
Date Created: | 2005-03-18 09:04:57 |