ODBC and JDBC Guide

Index
A
ABS function 52
Access via ODBC/JDBC extended privilege 21
accounts and privileges 21
aggregate functions in SQL 45
ALL operator 49
ALTER TABLE (SQL statement) 44
AND operator 50
ANY operator 49
ARRAY data type 30
ATAN function 52
ATAN2 function 52
auto-generated keys 29
B
B function 52
BETWEEN operator 49
binary data
use in SELECT 39
bitmap files in container fields 40
blank characters 48
blank value in columns 41
BLOB data type
use in SELECT 39
Boolean data type 30
C
CAST function 40, 58
catalog functions for ODBC 54
CEIL function 52
CEILING function 52
character operators in SQL expressions 48
CHR function 51
client application, using FileMaker as 6
CLOB data type 30
column aliases 35
column names 22
configuring a FileMaker data source
via JDBC 31
via ODBC (Mac OS) 24
via ODBC (Windows) 22
connections, database 8
constants in SQL expressions 47
container field
JDBC data type mapping 59
ODBC data type mapping 58
with INSERT statement 41
with SELECT statement 39
with UPDATE statement 43
container field, stored externally 43
container fields
use in CREATE TABLE 43
, 44
CREATE INDEX (SQL statement) 45
CREATE TABLE (SQL statement) 43
CURDATE function 53
CURRENT USER function 51
CURRENT_DATE function 53
CURRENT_TIME function 53
CURRENT_TIMESTAMP function 53
CURRENT_USER function 51
cursors
in JDBC 29
in ODBC 38
CURTIME function 53
CURTIMESTAMP function 53
D
data source
configuring for access via JDBC 31
configuring for access via ODBC (Mac OS) 24
configuring for access via ODBC (Windows) 22
disabling a shared FileMaker database file 8
one DSN for each FileMaker database file 9
verifying access via JDBC 32
verifying access via ODBC (Mac OS) 26
verifying access via ODBC (Windows) 24
data source names. See DSNs
data type mapping
JDBC client driver 58
ODBC client driver 58
database connections, number supported 8
database, DSN 23
DATALINK data type 30
date formats 47
DATE function 53
date operators in SQL expressions 48
DATEVAL function 53
DAY function 52
DAYNAME function 51
DAYOFWEEK function 52
DEFAULT (SQL clause) 43
DEG function 52
DEGREES function 52
DELETE (SQL statement) 41
disabling a shared FileMaker database file 8
DISTINCT operator 35
driver properties
JDBC client driver 31
ODBC client driver (Mac OS) 24
ODBC client driver (Windows) 22
drivers
uninstalling old 9
DROP INDEX (SQL statement) 45
DSNs
creating (Mac OS) 24
creating (Windows) 22
one per file 9