Problem Note 33648: The implicit pass-through facility does not correctly switch argument order for the DB2 LOCATE() function when you pass the INDEX() function to DB2
In the z/OS environment, when you use SAS/ACCESS® Interface to DB2 to pass arguments in the INDEX() function to DB2, the implicit pass-through facility does not correctly switch the argument order for the DB2 function LOCATE() function. As a result, incorrect results are generated.
For example, if you want to search a variable for the string ‘SMITH’ in SAS, the INDEX() function is written as follows:
index(emp_name,’SMITH’)
To perform an equivalent search in DB2, the syntax for the DB2 LOCATE() function is the following:
locate(‘SMITH’,emp_name)
When implicit pass-through converts the SAS code to DB2 code, it does not switch the order of the arguments like it should. As a result, the order of the LOCATE() arguments is incorrect:
locate(emp_name,’SMITH’)
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.1 TS1M3 SP4 | 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: | alert |
Date Modified: | 2009-09-14 13:18:36 |
Date Created: | 2008-10-14 16:36:47 |