DB2
UNIX/PC, ODBC Details: When SQL_FUNCTIONS= is
set to ALL, only the functions that are supported by the database
table drivers are passed. Only a fraction of the functions might be
available.
| DATE |
TODAY |
QTR |
COMPRESS |
SUBSTR |
| DATEPART |
DAY |
SECOND |
INDEX |
TRANWRD |
| DATETIME |
HOUR |
WEEKDAY |
LENGTH |
TRIMN |
| TIME |
MINUTE |
YEAR |
REPEAT |
MOD |
| TIMEPART |
MONTH |
BYTE |
SOUNDEX |
Use of this option can
cause unexpected results, especially if used for NULL processing and
date/time/timestamp handling. For example, the following SAS code
executed without SQL_FUNCTIONS= enabled returns the SAS date 15308:
proc sql;
select distinct DATE () from x.test;
quit;
However, the same code
with SQL_FUNCTIONS=ALL, returns 2001-1-29, which is an ODBC date format.
Care should be exercised when using this option.