ODBC and JDBC Guide

Index
A
ABS function 53
Access via ODBC/JDBC extended privilege 22
accounts and privileges 22
aggregate functions in SQL 46
ALL operator 49
ALTER TABLE (SQL statement) 44
AND operator 50
ANY operator 49
ARRAY data type 30
ATAN function 53
ATAN2 function 53
auto-generated keys 29
B
B function 53
BETWEEN operator 49
binary data
use in SELECT
40
bitmap files in container fields 41
blank characters 48
blank value in columns 42
BLOB data type
use in CREATE TABLE
44
use in SELECT 40
Boolean data type 30
C
CAST function 41, 59
catalog functions for ODBC 55
CEIL function 53
CEILING function 53
character operators in SQL expressions 48
CHR function 51
client application, using FileMaker as 7
CLOB data type 30
column aliases 36
column names 23
configuring a FileMaker data source
via JDBC
31
via ODBC (Mac OS) 25
via ODBC (Windows) 23
connections, database 9
constants in SQL expressions 47
container field
JDBC data type mapping
60
ODBC data type mapping 59
with INSERT statement 42
with SELECT statement 40
with UPDATE statement 43
CREATE INDEX (SQL statement) 45
CREATE TABLE (SQL statement) 44
CURDATE function 54
CURRENT USER function 51
CURRENT_DATE function 54
CURRENT_TIME function 54
CURRENT_TIMESTAMP function 54
CURRENT_USER function 51
cursors
in JDBC
29
in ODBC 39
CURTIME function 54
CURTIMESTAMP function 54
D
data source
configuring for access via JDBC
31
configuring for access via ODBC (Mac OS) 25
configuring for access via ODBC (Windows) 23
disabling a shared FileMaker database file 9
one DSN for each FileMaker database file 10
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
59
ODBC client driver 59
database connections, number supported 9
database, DSN 24
DATALINK data type 30
date formats 47
DATE function 54
date operators in SQL expressions 48
DATEVAL function 54
DAY function 53
DAYNAME function 51
DAYOFWEEK function 53
DEG function 53