Starting in SAS^® 9.2, the following additional functions might now be passed to DB2 for processing:

• DATEPART
• INDEX
• LEFT
• MINUTE
• QTR
• REPEAT
• RIGHT
• SECOND
• SIGN
• STRIP
• SUBSTR
• TRANSLATE
• TRANWRD
• TRIMN
• TRANSLATE
• TRANWRD
• TRIMN
• TODAY
• TRUNC
• WEEKDAY

• DATEPART
• LENGTH
• TIMEPART
• TODAY

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

This fix should enable these functions to be passed in SAS 9.1.3.

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: