Job Management Partner 1/Performance Management User's Guide

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

Table 12-3 Supported SQL functions

Function Supported item

Data type - Supported data types are as follows:

char

date

double

float

integer

long

real

smallint

time

timestamp

Tinyint

varchar

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.

Function	Supported item
Data type	-	Supported data types are as follows: char date double float integer long real smallint time timestamp Tinyint varchar
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.

[Contents][Back][Next]

[Trademarks]