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:

To perform an equivalent search in DB2, the syntax for the DB2 LOCATE() function is the following:

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:

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: