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

In addition, when the LIBNAME statement contains the SQL_FUNCTIONS=ALL option, then four additional functions are passed, even though they do not return the same results as SAS.

• 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

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS/ACCESS Interface to DB2	z/OS	9.1 TS1M3 SP4	9.2 TS1M0

* 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.

---

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

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#013450

---

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

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#013450

---

Type:	Problem Note
Priority:	medium
Topic:	Data Management ==> Data Sources ==> External Databases ==> DB2 SAS Reference ==> LIBNAME Engines

Date Modified:	2008-08-29 14:24:04
Date Created:	2004-09-27 15:31:05