A SERVICE OF

logo

The LIBNAME Statement for Relational Databases SQL_FUNCTIONS= LIBNAME Option 127
Details
DB2 UNIX/PC, ODBC Details: When SQL_FUNCTIONS= is set to ALL, only the
functions that are supported by the DBMS drivers are passed. Only a fraction of the
functions may be available, based on your provider:
DATE
DATEPART
DATETIME
TIME
TIMEPART
TODAY
DAY
HOUR
MINUTE
MONTH
QRT
SECOND
WEEKDAY
YEAR
BYTE
COMPRESS
INDEX
LENGTH
REPEAT
SOUNDEX
SUBSTR
TRANWRD
TRIMN
MOD
OLE DB Details: When SQL_FUNCTIONS= is set to ALL, the following functions
are passed to the DBMS, regardless of whether they are supported by the driver:
LOWCASE
UPCASE
ABS
ARCOS
ARSIN
ATAN
CEIL
COS