ODBC and JDBC Developer’s Guide

Index
A
aggregate functions in SQL 35
ALTER TABLE (SQL statement) 31
B
blank space in database name 17, 22
C
CAST function 28, 43
catalog functions for ODBC 42
character operators in SQL expressions 37
client application, using FileMaker 9
configuring a FileMaker data source
via JDBC 22
via ODBC (Mac OS) 16
via ODBC (Windows) 13
constants in SQL expressions 36
container field 27
CREATE INDEX (SQL statement) 31
CREATE TABLE (SQL statement) 30
D
data source
configuring for access via JDBC 22
configuring for access via ODBC (Mac OS) 16
configuring for access via ODBC (Windows) 13
disabling a shared FileMaker database file 8
one DSN for each FileMaker database file 10
using a FileMaker database file 8
verifying access via JDBC 23
verifying access via ODBC (Mac OS) 17
verifying access via ODBC (Windows) 15
Data Source Name 14
data type mapping
JDBC client driver 45
ODBC client driver 43
date operators in SQL expressions 37
DELETE (SQL statement) 28
disabling a shared FileMaker database file 8
driver properties
JDBC client driver 22
ODBC client driver (Mac OS) 16
ODBC client driver (Windows) 13
DROP INDEX (SQL statement) 32
E
escape character 17, 22
exponential notation in SQL expressions 37
expressions in SQL 35
F
field names in SQL expressions 36
FOR UPDATE (SQL clause) 34
FROM (SQL clause) 32
functions in SQL expressions 39
G
GetAs function 28, 43
GROUP BY (SQL clause) 33
H
HAVING (SQL clause) 33
hosting a FileMaker data source 8
I
INNER JOIN 32
INSERT (SQL statement) 29
J
Java Development Kit (JDK) 20
JDBC client driver
driver class and main entry point 20
installing 20
mapping data types 45
meta data functions 42
registering with the JDBC driver manager 20
repeating fields 25
specifying the JDBC URL 20
Unicode support 25
verifying access 23
JDBC, described 19
join 32
L
literals in SQL expressions 36
Local Data Access Companion (LDAC) 9
logical operators in SQL expressions 39