ODBC and JDBC Guide

62
E
empty string
use in SELECT 39
error message formats 59
Execute SQL script step 11
ExecuteSQL function 11
EXISTS operator 49
EXP function 52
exponential notation in SQL expressions 48
expressions in SQL 46
extended privileges 21
EXTERNAL (SQL clause) 43
F
field names in SQL expressions 46
field repetitions 43
fields
mapping to JDBC 58
mapping to ODBC 58
FileMaker products 8
files
organizing on one computer 8
setting up access to 21
use in container fields 40
FLOOR function 52
FOR UPDATE (SQL clause) 38
FROM (SQL clause) 35
FULL OUTER JOIN 36
functions in SQL expressions 51
G
GetAs function 40, 58
GROUP BY (SQL clause) 37
H
HAVING (SQL clause) 37
holdable cursor 29
host, DSN 23
, 25
HOUR function 52
I
image files in container fields 40
Import Records script step 11
IN operator 49
INNER JOIN 36
INSERT (SQL statement) 41
installation requirements 13
, 27
INT function 52
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 59
overview of using 6
JDBC client driver
driver class and main entry point 30
mapping data types 58
meta data functions 54
portals 34
registering with the JDBC driver manager 30
specifying the JDBC URL 30
Unicode support 34
verifying access 32
JDBC SPI 30
join 36
K
keywords, reserved SQL 55
L
LEFT function 51
LEFT JOIN 36
LEFT OUTER JOIN 36
LEN function 52
LIKE operator 49
LN function 53
LOG function 53
logical operators in SQL expressions 50
LOWER function 51
LTRIM function 51
M
Mac OS
creating a DSN 24
JDBC client driver requirements 27
ODBC client driver requirements 13
verifying ODBC access 26
mapping data types
JDBC client driver 58
ODBC client driver 58
MAX function 53
meta data functions for JDBC 54
MIN function 53
MINUTE function 53
MOD function 52
MONTH function 52
MONTHNAME function 51