Passing SAS Functions to OLE DB

SAS/ACCESS Interface to OLE DB passes the following SAS functions for OLE DB to DB2, Microsoft SQL Server, and Oracle for processing. Where the OLE DB function name differs from the SAS function name, the OLE DB name appears in parentheses. For more information, see Passing Functions to the DBMS Using PROC SQL.
DAY MINUTE
DTEXTDAY MONTH
DTEXTMONTH SECOND
DTEXTYEAR WEEKDAY
DTEXTWEEKDAY YEAR
HOUR
SQL_FUNCTIONS=ALL allows for SAS functions that have slightly different behavior from corresponding database functions that are passed down to the database. (See SQL_FUNCTIONS=.) Only when SQL_FUNCTIONS=ALL can the SAS/ACCESS engine also pass these SAS SQL functions to OLE DB. Due to incompatibility in date and time functions between OLE DB and SAS, OLE DB might not process them correctly. Check your results to determine whether these functions are working as expected.
ABS MAX
ARCOS (ACOS) MIN
ARSIN (ASIN) MOD
ATAN QRT
AVG REPEAT
BYTE SIGN
CEIL SIN
COMPRESS SOUNDEX
COS SQRT
COUNT STRIP (TRIM)
DATE SUBSTR
DATEPART SUM
DATETIME TAN
EXP TIME
FLOOR TIMEPART
INDEX TODAY
LENGTH TRANWRD
LOG TRIM
LOG10 UPCASE
LOWCASE