ODBC and JDBC Guide

64 FileMaker ODBC and JDBC Guide
Server Data Source 26
sharing, setting up ODBC/JDBC 22
SIGN function 54
SIN function 54
SPACE function 51
SQL aggregate functions 46
SQL expressions 46
character operators 48
constants 47
date operators 48
exponential or scientific notation 48
field names 47
functions 50
literals 47
logical operators 50
numeric operators 48
operator precedence 54
relational operators 49
SQL standards compliance 35
SQL statements
ALTER TABLE
44
CREATE INDEX 45
CREATE TABLE 44
DELETE 42
DROP INDEX 45
INSERT 42
reserved keywords 55
SELECT 35
supported by client drivers 35
UPDATE 43
SQL_C_WCHAR data type 35
SQL-92 35
SQLExceptions 60
SQRT function 54
standards compliance 35
string functions 51
STRVAL function 51
subqueries 42
SUBSTR function 51
SUBSTRING function 51
syntax errors 55
system requirements 15, 27
T
table aliases 36, 37
TAN function 54
testing access
JDBC client driver
32
ODBC client driver (Mac OS) 26
ODBC client driver (Windows) 24
time formats 47
TIME function 51
timestamp formats 47
TIMESTAMPVAL function 54
TIMEVAL function 51
TODAY function 54
TRIM function 51
U
Unicode support 35
UNION (SQL operator) 38
UPDATE (SQL statement) 43
UPPER function 51
URL (Uniform Resource Locator) for the JDBC cli-
ent driver
30
USERNAME function 51
V
VAL function 54
VALUES (SQL clause) 42
verifying access
JDBC client driver
32
ODBC client driver (Mac OS) 26
ODBC client driver (Windows) 24
W
WHERE (SQL clause) 37
Windows
creating a DSN
23
JDBC client driver requirements 27
ODBC client driver requirements 15
verifying ODBC access 24
X
X function 54
Y
YEAR function 54