ODBC and JDBC Guide

62 FileMaker ODBC and JDBC Guide
DEGREES function 53
DELETE (SQL statement) 42
disabling a shared FileMaker database file 9
DISTINCT operator 36
driver properties
JDBC client driver
31
ODBC client driver (Mac OS) 25
ODBC client driver (Windows) 23
drivers
uninstalling old
10
DROP INDEX (SQL statement) 45
DSNs
creating (Mac OS)
25
creating (Windows) 23
one per file 10
E
empty string
use in SELECT
40
error message formats 60
EXISTS operator 49
EXP function 53
exponential notation in SQL expressions 48
expressions in SQL 46
extended privileges 22
F
field names in SQL expressions 47
fields
mapping to JDBC
59
mapping to ODBC 59
FileMaker products 9
files
organizing on one computer
9
setting up access to 22
use in container fields 41
FLOOR function 53
FOR UPDATE (SQL clause) 39
FROM (SQL clause) 37
FULL OUTER JOIN 37
functions in SQL expressions 50
G
GetAs function 41, 59
GROUP BY (SQL clause) 38
H
HAVING (SQL clause) 38
holdable cursor 29
host, DSN 23, 25
HOUR function 53
I
image files in container fields 41
IN operator 49
INNER JOIN 37
INSERT (SQL statement) 42
installation requirements 15, 27
INT function 53
IS NOT NULL operator 49
IS NULL operator 49
J
Java Development Kit (JDK) 30
Java version 27
JDBC
client driver, described
29
described 29
error messages 60
overview of using 7
JDBC client driver
driver class and main entry point
30
mapping data types 59
meta data functions 55
portals 35
registering with the JDBC driver manager 30
specifying the JDBC URL 30
Unicode support 35
verifying access 32
JDBC SPI 30
join 37
K
keywords, reserved SQL 55
L
LEFT function 51
LEFT JOIN 37
LEFT OUTER JOIN 37
LEN function 53
LIKE operator 49
literals in SQL expressions 47
LN function 53