15.4.1 Supported SQL functions
The PFM ODBC driver is a read-only driver that supports a subset of SQL-92 entry level. The following table lists and describes SQL functions supported by the PFM ODBC driver.
|
Function |
Supported item |
|
|---|---|---|
|
Data type |
- |
Supported data types are as follows:
|
|
Syntax |
Statement |
Only the SELECT statement is supported. |
|
GROUP BY clause |
Supported. |
|
|
ORDER BY clause |
Supported. |
|
|
WHERE clause |
Supported. |
|
|
FROM clause |
Only one table can be specified for each query. |
|
|
Search condition |
Symbols including <, >, <=, >=, =, <>, IN, AND, OR, and NOT are supported as comparison predicates. Note that subqueries are not available. |
|
|
Expression |
Supported only in SELECT lists. |
|
|
Escape sequence |
Date, time, and time-stamp (d, t, ts) are supported. |
|
- Legend:
-
--: Not supported