FileMaker ODBC and JDBC Guide

FileMaker 12 ODBC JDBC

2004 2012 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. Bento FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgements URL www.filemaker.co.jp 01

1 6 6 ODBC JDBC 6 ODBC FileMaker 7 ODBC 7 ODBC 7 FileMaker 8 FileMaker Pro 8 9 9 9 9 2 SQL 10 ODBC 10 ODBC SQL 11 ODBC 12 FileMaker 12 12 ODBC 12 3 FileMaker ODBC 14 14 ODBC Windows 14 ODBC Mac OS 14 14 ODBC 15 ODBC Windows 15 Windows 16 ODBC Windows 16 DSN Windows 17 ODBC Mac OS 18 Mac OS 19 20

4 4 ODBC FileMaker 21 ODBC 21 ODBC 22 FileMaker 23 Windows FileMaker 23 FileMaker DSN ODBC Windows 23 ODBC Windows 23 ODBC Windows 25 Mac OS FileMaker 26 FileMaker DSN ODBC Mac OS 26 ODBC Mac OS 26 ODBC Mac OS 27 5 FileMaker JDBC 29 29 29 JDBC 29 JDBC 30 6 JDBC FileMaker 31 JDBC 31 JDBC 31 JDBC 32 JDBC URL 33 URL 34 FileMaker 35 JDBC 35 7 36 Unicode 36 SQL 36 SELECT 37 SQL 37 FROM 37 WHERE 38 GROUP BY 39 HAVING 39 UNION 39

5 ORDER BY 40 FOR UPDATE 40 DELETE 43 INSERT 43 UPDATE 44 CREATE TABLE 45 ALTER TABLE 46 CREATE INDEX 46 DROP INDEX 47 SQL 47 SQL 48 48 49 49 50 50 50 50 52 52 53 54 55 55 ODBC 56 JDBC 56 SQL 56 8 60 FileMaker ODBC 60 FileMaker JDBC 60 64 61 ODBC JDBC 61 ODBC 61 JDBC 61 63

1 FileMaker ODBC ODBC JDBC FileMaker ODBC JDBC 1 ODBC FileMaker 1. 2. ODBC 1 FileMaker Pro 1 FileMaker Pro Advanced 1 2 1 FileMaker Pro [ ] > [ ] 1 FileMaker Server 1 SQL [ ] 1 FileMaker Server ODBC [SQL ] Advanced [ExecuteSQL] 1 FileMaker 1 FileMaker Pro ODBC 1. SQL 2. ODBC JDBC 1 FileMaker Pro 1 FileMaker Pro Advanced 1 FileMaker Server Advanced 3 8 1 FileMaker Pro ODBC JDBC www.filemaker.co.jp 1 ODBC JDBC SQL 1 FileMaker Pro Advanced FileMaker ProFileMaker Pro FileMaker Pro Advanced FileMaker www.filemaker.co.jp Web ODBC JDBC ODBC JDBC APIODBC C API JDBC Java API API FileMaker Pro FileMaker Server Advanced ODBC JDBC SQL SQL

1 7 ODBC JDBC API FileMaker ODBC FileMaker ODBC FileMaker SQL FileMaker ODBC SQL ODBC ODBC ODBC ODBC 1 [ ] ODBC FileMaker Pro SQL SQL 1 [ ] [SQL ] [ExecuteSQL] FileMaker SQL SQL ODBC SQL ODBC ODBC ODBC ODBC FileMaker SQL 1 ODBC 1 ODBC ODBC 1 1 FileMaker ODBC FileMaker Pro ODBC SQL FileMaker Pro OracleSQL Server MySQL FileMaker Pro ODBC 2 SQL FileMaker ODBC

1 8 FileMaker FileMaker ODBC JDBC FileMaker FileMaker ODBC JDBC SQL FileMaker FileMaker Pro FileMaker Server Advanced FileMaker Pro FileMaker ODBC JDBC FileMaker FileMaker FileMaker Server Advanced FileMaker Pro 50 Web FileMaker FileMaker ODBC JDBC FileMaker Server Advanced FileMaker Pro FileMaker ODBC ODBC ODBC JDBC FileMaker Pro FileMaker Server Advanced ODBCOpen Database ConnectivityJDBCJava Database Connectivity SQL 1 ODBC FileMaker 3 FileMaker ODBC 1 FileMaker FileMaker ODBC 4 ODBC FileMaker 1 JDBC FileMaker 5 FileMaker JDBC 1 FileMaker JDBC FileMaker Java 6 JDBC FileMaker 1 ODBC JDBC FileMaker Pro FileMaker Server Advanced SQL 7 ODBC/JDBC FileMaker Server Advanced FileMaker Pro ODBC JDBC FileMaker FileMaker

1 9 Microsoft AccessMicrosoft Access FileMaker Microsoft Access Microsoft Access FileMaker Server Advanced FileMaker TCP/IP FileMaker Pro FileMaker Pro FileMaker Server Advanced 12 FileMaker 12 FileMaker Pro FileMaker Server Advanced 3 FileMaker ODBC 5 FileMaker JDBC FileMaker DSN DSN FileMaker DSN

2 SQL ODBC FileMaker SQL FileMaker ODBC SQL ODBC ODBC ODBC ODBC ODBC Oracle Oracle ODBC ODBC SQL ODBC FileMaker Pro SQL ODBC FileMaker Pro ODBC Oracle Microsoft Access FileMaker Pro FileMaker Pro [ ] [ ] [SQL ] [ExecuteSQL] ODBC ODBC 1 ODBC 1 FileMaker Pro ODBC DSN 1 ODBC

2 SQL 11 1 FileMaker Pro 1 FileMaker Pro [] > [] > [ODBC...] 1 FileMaker Pro [ ] > [...] [...] [ ]Windows [ ]Mac OS [ODBC...] [OK] FileMaker Pro SQL FileMaker Pro SQL SQL [WHERE] [ORDER BY] SQL Query SQL [ ] [SQL ] [ExecuteSQL] FileMaker ODBC [SQL ] SQL FileMaker Pro Advanced SQL FileMaker FileMaker Pro ODBC SQL ODBC FileMaker Pro [SQL ] [ExecuteSQL] SQL INSERTUPDATE DELETE SQL FileMaker Pro SQL FileMaker Pro SQL Server SQL [SQL ] [ExecuteSQL] FileMaker FileMaker Pro

2 SQL 12 ODBC ODBC FileMaker SQL ODBC FileMaker Pro FileMaker Server SQL ODBC FileMaker Pro FileMaker Pro FileMaker Pro FileMaker Server SQL FileMaker Pro FileMaker 12 ODBC FileMaker ODBC SQL 1 Oracle 10g 1 Oracle 11g 1 SQL Server 2005 1 SQL Server 2008 1 MySQL 5.1 Community Edition www.filemaker.co.jp/support/technologies ODBC ODBC FileMaker Pro 1 ODBC 1 FileMaker Pro ODBC DSN 1 ODBC 1 ODBC FileMaker Pro

2 SQL 13 1 FileMaker Pro 1 ODBC ODBC ODBC ODBC ODBC FileMaker Pro

3 FileMaker ODBC ODBCOpen Database Connectivity FileMaker ODBC ODBC FileMaker xdbc FileMaker http://filemaker-jp.custhelp.com URL www.filemaker.co.jp/support/technologies FileMaker Server Advanced FileMaker FileMaker SQL ODBC ODBC Windows 1 Pentium III 700MHz 1 Windows XP 256 MB RAM 2 GBWindows VistaWindows 7 Windows Server 2008 R2 1 GB RAM 1 Microsoft Data Access ComponentsMDAC 2.8 SP1Vista Windows MDAC 6.0MDAC Windows Windows ODBC Mac OS 1 Intel Mac OS 1 1 GB RAM 2 GB 1 Mac OS X 10.6FileMaker FileMaker TCP/IP

3 FileMaker ODBC 15 ODBC FileMaker Windows Mac OS 32 64 32 64 ODBC FileMaker Pro 32 xdbc Listener FileMaker Server Advanced 32 32 xdbc Listener64 64 xdbc Listener 32 64 xdbc Listener 32 64 ODBC ODBC 32 32 ODBC 64 64 ODBC Windows Windows 32 64 32 Windows 32 64 Windows 32 64 ODBC 1. 1.exe 1 2. FileMaker Pro FileMaker Server xdbc 3. xdbcodbc Client Driver Installer 4. ODBC Client Driver Installer 1 32 fmodbc32.dll32 [FMODBC_Installer_Win32.msi] 1 64 fmodbc64.dll64 [FMODBC_Installer_Win64.msi] FileMaker ODBC Driver Setup Wizard 5. ODBC

3 FileMaker ODBC 16 6. [ ] ODBC 1 32 Windows 32 fmodbc32.dll c:windowssystem32 1 64 Windows 32 fmodbc32.dll c:windowssyswow64 1 64 Windows 64 fmodbc64.dll c:windowssystem32 FileMaker ODBC [FileMaker ODBC] Windows ODBC FileMaker FileMaker 2399 ODBC Windows 32 32 ODBC 64 64 ODBC 32 Windows 32 ODBC Windows [ ] > [ (ODBC)] 1 Windows XP [ ] [ ] 1 Windows Vista Windows 7 [ ] [ ] 32 [ODBC ] 64 Windows 32 ODBC 1. SysWoW64SysWoW64 c: windowssyswow64 2. odbcad32.exe 32 [ODBC ]

3 FileMaker ODBC 17 64 Windows 64 ODBC Windows [ ] > [ (ODBC)] 1 Windows XP [ ] [ ] 1 Windows Vista Windows 7 [ ] [ ] 64 [ODBC ] DSN Windows ODBC 1. [ODBC ] [ DSN] [ DSN] 2. [...] [ ] 3. [FileMaker ODBC] [ ] [FileMaker DSN ] 4. [ ] 5. [ ] FileMaker [ ] FileMaker [ ] 6. [ ] 1 FileMaker Pro localhost IP 127.0.0.1 1 FileMaker Server Advanced FileMaker Server IP ODBC/JDBC [ ] [ ] [ ]

3 FileMaker ODBC 18 7. [ ] FileMaker FileMaker Server Advanced [ ] FileMaker Server [ ] [ ] 1 [ ] 1 [ ] MS Word 255 PHP [ long varchar ] 255 Windows 255 Mac OS [ ] [ ] 8. FileMaker DSN 1 [ ] FileMaker ODBC FileMaker FileMaker ODBC/JDBC FileMaker Pro FileMaker Server Advanced ODBC/JDBC 1 [ ] ODBC Mac OS Mac OS 32 64 / /ODBC FileMaker ODBC.bundleODBC ODBC 1. 1.dmg 1 2. FileMaker Pro FileMaker Server xdbc 3. xdbcodbc Client Driver Installer 4. ODBC Client Driver Installer [FileMaker ODBC.mpkg] FileMaker ODBC Driver Installer

3 FileMaker ODBC 19 5. ODBC 6. [ ] ODBC / /ODBC ODBC FileMaker ODBC [FileMaker ODBC] Mac OS ODBC FileMaker www.odbcmanager.net FileMaker Actual Technologies ODBC Manager Apple ODBC Administrator Tool for Mac OS X Mac OS X 10.6 ODBC Administrator http://support.apple.com/downloads/odbc_administrator_tool_for_mac_os_x 32 64 1 ODBC 32 64 ODBC FileMaker DSN 32 64 ODBC FileMaker 2399 ODBC 1. ODBC Manager ODBC Manager 2. [ DSN] [ DSN] [...] [ ] 3. [FileMaker ODBC] [OK] [FileMaker DSN ] 4. [ ] 5. [ ] FileMaker [ ] FileMaker [ ] 6. [ ] 1 FileMaker Pro localhost IP 127.0.0.1 1 FileMaker Server Advanced FileMaker Server IP ODBC/JDBC [ ] [ ] [ ]

3 FileMaker ODBC 20 7. [ ] FileMaker FileMaker Server Advanced [ ] FileMaker Server [ ] [ ] 1 [ ] 1 [ ] MS Word 255 PHP [ long varchar ] [ ] [ ] 8. FileMaker DSN 1 [ ] FileMaker ODBC FileMaker FileMaker ODBC/JDBC FileMaker Pro FileMaker Server Advanced ODBC/JDBC 1 [ ] SQL FileMaker ODBC [ ] [SQL ] ODBC FileMaker 4 ODBC FileMaker

4 ODBC FileMaker ODBC FileMaker ODBC FileMaker FileMaker ODBC FileMaker ODBC FileMaker Pro ODBC SQL ODBC ODBC SQL 2 SQL ODBC ODBC API ODBC ODBC SQL SQL FileMaker ODBC SQL 7 ODBC FileMaker SQL FileMaker FileMaker Server Advanced FileMaker /

4 ODBC FileMaker 22 Oracle ODBC SQL Server ODBC FileMaker ODBC Oracle Microsoft SQL Server FileMaker ODBC ODBC ODBC FileMaker 1 Microsoft Word 1 Microsoft Excel 1 FileMaker Microsoft SQL Server DBMS 1 FileMaker 1 FileMaker Pro Microsoft Visual Basic FileMaker FileMaker Pro [ODBC/JDBC ] FileMaker Server Advanced FileMaker Pro ODBC/JDBC FileMaker Pro FileMaker Server FileMaker ODBC FileMaker 12 FileMaker 12 ODBC FileMaker xdbc Listener Mac OS Windows FileMaker xdbc Listener fmxdbc_listener FileMaker xdbc Listener FileMaker Server

4 ODBC FileMaker 23 FileMaker ODBC SQL FileMaker SQL ODBC FileMaker 1. FileMaker Pro [ODBC/JDBC ] 2. FileMaker Server AdvancedFileMaker Server Admin Console FileMaker Pro ODBC/JDBC FileMaker Server Admin Console [ODBC/JDBC] [ODBC/JDBC ] FileMaker Pro [ ] > [ ] > [ODBC/JDBC...] [ODBC/JDBC ] [ ] 3. FileMaker FileMaker FileMaker 4. FileMaker 5. SQL FileMaker FileMaker DSN FileMaker Windows FileMaker FileMaker DSN ODBC Windows FileMaker DSN DSN FileMaker ODBC FileMaker FileMaker ODBC 16 Windows ODBC Windows ODBC ODBC 32 32 ODBC 64 64 ODBC

4 ODBC FileMaker 24 32 Windows 32 ODBC Windows [ ] > [ (ODBC)] 1 Windows XP [ ] [ ] 1 Windows Vista Windows 7 [ ] [ ] 32 [ODBC ] 64 Windows 32 ODBC 1. SysWoW64SysWoW64 c:windowssyswow64 2. odbcad32.exe 32 [ODBC ] 64 Windows 64 ODBC Windows [ ] > [ (ODBC)] 1 Windows XP [ ] [ ] 1 Windows Vista Windows 7 [ ] [ ] 64 [ODBC ] ODBC 1. [ODBC ] [ DSN] [ DSN] 2. FileMaker [ ] [ ] [FileMaker ODBC] 3. [...] [FileMaker DSN ] 4. [ ] FileMaker [ ] FileMaker [ ] 5. [ ] FileMaker Pro FileMaker 127.0.0.1localhost FileMaker Server Advanced FileMaker FileMaker Server IP ODBC/JDBC [ ]

4 ODBC FileMaker 25 6. [ ] FileMaker FileMaker Server Advanced [ ] FileMaker Server [ ] [ ] 1 [ ] 1 [ ] MS Word 255 PHP [ long varchar ] [ ] 7. [ ] 8. [ ] [FileMaker DSN ] ODBC Windows FileMaker ODBC 1. Windows [ ] > [ (ODBC)] 1 Windows XP [ ] [ ] 1 Windows Vista Windows 7 [ ] [ ] [ODBC ] 2. [ DSN] [ DSN] 3. FileMaker [ ] [ ] [FileMaker ODBC] 4. [...] [FileMaker DSN ] 5. [ ] [ ] 6. [ ] FileMaker [ ] [ ]

4 ODBC FileMaker 26 1 FileMaker 1 1 FileMaker [ODBC/JDBC ] 1 FileMaker Pro FileMaker Server ODBC/JDBC Mac OS FileMaker FileMaker DSN ODBC Mac OS FileMaker DSN DSN FileMaker ODBC FileMaker FileMaker ODBC 19 Mac OS ODBC Mac OS www.odbcmanager.net FileMaker Actual Technologies ODBC Manager Apple ODBC Administrator Tool for Mac OS X Mac OS X 10.6 ODBC Administrator http://support.apple.com/downloads/odbc_administrator_tool_for_mac_os_x 32 64 1 ODBC 32 64 ODBC FileMaker DSN 32 64 ODBC ODBC 1. ODBC Manager ODBC Manager 2. [ DSN] [ DSN] 3. FileMaker [ ] [ ] [FileMaker ODBC] 4. [...] [FileMaker DSN ] 5. [ ] 6. [ ] FileMaker [ ]

4 ODBC FileMaker 27 7. [ ] FileMaker Pro FileMaker 127.0.0.1localhost FileMaker Server Advanced FileMaker FileMaker Server IP ODBC/JDBC [ ] 8. [ ] FileMaker FileMaker Server Advanced [ ] FileMaker Server [ ] [ ] 1 [ ] 1 [ ] MS Word 255 PHP [ long varchar ] [ ] 9. [ ] 10. [ ] [FileMaker DSN ] ODBC Mac OS FileMaker ODBC 1. ODBC Manager ODBC Manager 2. [ DSN] [ DSN] 3. FileMaker [ ] [ ] [FileMaker ODBC] 4. [...] [FileMaker DSN ]

4 ODBC FileMaker 28 5. [ ] [ ] 6. [ ] FileMaker [ ] [ ] 1 FileMaker 1 1 FileMaker [ODBC/JDBC ] 1 FileMaker Pro FileMaker Server ODBC/JDBC

5 FileMaker JDBC JDBCJava Database Connectivity FileMaker FileMaker DVDxDBC URL www.filemaker.co.jp/support/technologies FileMaker Server Advanced FileMaker FileMaker SQL JDBC FileMaker JDBC FileMaker JDBC JDK 1.4 Java Windows Mac OSjava -version FileMaker TCP/IP JDBC JDBC JDBC 1. 1 Windows.exe 1 Mac OS.dmg 1 2. FileMaker Pro FileMaker Server xdbc 3. xdbcjdbc Client Driver Installer

5 FileMaker JDBC 30 4. fmjdbc.jar 1 Windowsfmjdbc.jar Java java.exe Java ClassPath 1 Mac OSfmjdbc.jar/ /Java/Extensions Java ClassPath FileMaker JDBC JDBC JDBC Java JDBC JDBC URL FileMaker JDBC 2399 2399 JDBC JDBC 6 JDBC FileMaker

6 JDBC FileMaker Java JDBC RADRapid Application Development FileMaker Java JDBC Java FileMaker JDBC JDBC SQL Java API JDBC Java ODBC Java Database Connectivity JDBC JDBC SQL JDBC Java FileMaker SQL FileMaker FileMaker Server Java FileMaker / Java JDBC FileMaker JDBC Java Java RAD JDBC Java JDBC JDBC JDBC Java JDBC URL JDBC URL

6 JDBC FileMaker 32 JDBC JDBC JDBC 3.0 FileMaker 1 1 1 1 1 Ref 1 CLOBARRAY REF 1 1 DATALINK 1 1 JDBC SPI www.filemaker.co.jp/support/technologies JDBC Java Development Kit (JDK) 1.5 (Mac OS) 1.6 (Windows) FileMaker JDBC Java JDBC Java com.filemaker.jdbc.driver FileMaker FileMaker JDBC JDBC FileMaker FileMaker xdbc Listener Mac OS Windows FileMaker xdbc Listener fmxdbc_listener FileMaker xdbc Listener FileMaker Server

6 JDBC FileMaker 33 JDBC URL Java URLUniform Resource LocatorJDBC URL JDBC jdbc:< >:< > JDBC URL JDBC jdbc< > JDBC < > filemaker < > FileMaker IP JDBC FileMaker JDBC 1. JDBC JDBC 2. FileMaker JDBC URL jdbc:filemaker://192.168.1.1/database 3. import java.sql.*; class FMPJDBCTest { public static void main(string[ ] args) { // register the JDBC client driver try { Driver d = (Driver)Class.forName("com.filemaker.jdbc.Driver").newInstance(); } catch(exception e) { System.out.println(e); } // establish a connection to FileMaker Connection con; try { con = DriverManager.getConnection("jdbc:filemaker://192.168.1.1/mydatabase","username", "password"); } catch (Exception e) { System.out.println(e); } // get connection warnings SQLWarning warning = null; try { warning = con.getwarnings(); if (warning == null) { System.out.println("No warnings"); return; } while (warning!= null) { System.out.println("Warning:"+warning); warning = warning.getnextwarning();

6 JDBC FileMaker 34 } } } } catch (Exception e) { Sysem.out.println(e); } URL user password JDBC URL DriverManager.GetConnection 1 user:[odbc/jdbc ] FileMaker 1 password:filemaker URL JDBC URL jdbc:filemaker://<filemaker IP >/< > jdbc:filemaker://192.168.1.1/publications URL JDBC URL jdbc:filemaker://<filemaker IP >/< >?user=< > &password=< > jdbc:filemaker://192.168.1.1/customers?user=collections&password=admin & jdbc:filemaker://localhost/sales_db?user=ad&min&password=admin jdbc:filemaker://localhost/sales_db?user=admin1&password=ad&min

6 JDBC FileMaker 35 FileMaker JDBC URL FileMaker JDBC JDBC FileMaker 1 FileMaker 1 FileMaker [ODBC/JDBC ] 1 FileMaker Pro FileMaker Server Advanced ODBC/JDBC FileMaker FileMaker Pro [ODBC/JDBC ] FileMaker Server Advanced FileMaker Pro ODBC/JDBC FileMaker Pro 1 JDBC JDBC URL Java JDBC FileMaker www.filemaker.co.jp/support/technologies

7 FileMaker ODBC JDBC SQL ODBC JDBC FileMaker FileMaker FileMaker Pro FileMaker Server Advanced ODBC Level 2 ODBC 3.5 Level 1 JDBC JDBC 3.0 www.filemaker.co.jp/support/technologies ODBC JDBC SQL- 92 SQL-92 Unicode ODBC JDBC Unicode API Unicode ASCII Unicode SQL_C_WCHAR SQL ODBC JDBC SQL 1 SELECT 1 DELETE43 1 INSERT43 1 UPDATE44 1 CREATE TABLE45 1 ALTER TABLE46 1 CREATE INDEX46 1 DROP INDEX47 FileMaker ODBC SQL JDBC SQL 60 FileMaker ODBC 60 FileMaker JDBC SQL ODBC JDBC FileMaker ""

7 37 SELECT SELECT SELECT * 1.05 SELECT SELECT [DISTINCT] {* [[AS] ],...} FROM [ ],... [ WHERE 1 2 ] [ GROUP BY {,...} ] [ HAVING 1 2 ] [ UNION [ALL] (SELECT...) ] [ ORDER BY { [DESC ASC]},...] [ FOR UPDATE [OF {,...} ] ] [] SELECT " " AS " " FROM " ".. DISTINCT SELECT DISTINCT " " FROM " " SQL ODBC JDBC SQL SQL FROM37 WHERE38 GROUP BY39 HAVING39 UNION39 ORDER BY40 SELECT FileMaker Pro FileMaker Pro 20,000,000 SELECT FOR UPDATE40 SQL SELECT FROM FROM SELECT FROM [ ] [, [ ]]

7 38 FROM E E. SELECT SELECT * FROM " " "E", " " "F" WHERE "E"." " = "F"." " = INNER JOIN SELECT * FROM " " INNER JOIN " " ON " "." " = " "." " LEFT JOIN SELECT * FROM " " LEFT JOIN " " ON " "." " = " "." " RIGHT JOIN SELECT * FROM " " RIGHT JOIN " " ON " "." " = " "." " 1 LEFT JOIN LEFT OUTER JOIN 1 RIGHT JOIN RIGHT OUTER JOIN 1 FULL OUTER JOIN WHERE WHERE WHERE WHERE 1 2 1 2 SELECT 2,000,000 SELECT " "," " FROM " " WHERE " " >= 2000000 WHERE WHERE 1 IS NULL WHERE NOT 2 SELECT WHERE

7 39 GROUP BY GROUP BY GROUP BY SELECT SELECT " ", SUM ( " " ) FROM " " GROUP BY " " HAVING HAVING 20,000,000 HAVING 1 2 1 2 SELECT 20,000,000 SELECT " ", SUM ( " " ) FROM " " GROUP BY " " HAVING SUM ( " " ) > 20000000 UNION UNION SELECT SELECT ALL UNION ALL SELECT UNION [ALL] SELECT UNION SELECT SELECT " ", " ", " " FROM " " UNION SELECT " ", " ", " " FROM " " SELECT SELECT " ", " " FROM " " UNION SELECT " ", " " FROM " "

7 40 ORDER BY ORDER BY ORDER BY { [DESC ASC]},... ASC SELECT SELECT " ", " ", " " FROM " " ORDER BY " ", " " SELECT " ", " ", " " FROM " " ORDER BY 2, 3 2 SELECT ORDER BY 2 FOR UPDATE FOR UPDATE SQL FOR UPDATE [OF ] 2,000,000 SELECT * FROM " " WHERE " " > 2000000 FOR UPDATE OF " ", " ", " "

7 41 SQL SELECT 'CatDog' FROM " " SELECT 999 FROM " " SELECT DATE '2012-06-05' FROM " " SELECT TIME '02:49:03' FROM " " SELECT TIMESTAMP '2012-06-05 02:49:03' FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " BLOB a SELECT " " FROM " " SELECT GETAS(" ", 'JPEG') FROM " " * SELECT * FROM " " SELECT DISTINCT * FROM " " a. BLOB FileMaker FileMaker *SELECT * FROM " " SELECT DISTINCT * FROM " " 1 FileMaker SELECT * FROM WHERE c = SELECT * FROM WHERE c <> 1 SELECT GetAs() CAST() GetAs() CAST() GetAs() SELECT SELECT " " FROM " " JPEG SELECT SELECT < >

7 42 Quicktime SELECT CAST() SELECT CAST(" " AS VARCHAR("NNN")) FROM " " 1 FileMaker Pro SELECT SQL_VARCHAR 1 FileMaker Pro SELECT 1 SELECT?FileMaker Pro.dat GetAs() FileMaker Pro 1 [ ] > [...] GetAs() FILE SELECT GetAs(" ", 'FILE') FROM " " 1 [ ] > [...] - Mac OS GetAs() snd SELECT GetAs(" ", 'snd ') FROM " " 1 [ ] > [...] SELECT GetAs(" ", 'JPEG') FROM " " 'EMF+' Windows Enhanced Metafile Plus 'PDF ' Portable Document Format 'EPS ' Embedded PostScript 'PICT' Mac OS512- 'FPix' FlashFPX 'PNGf' Bitmap 'FORK' Mac OS 'PNTG' MacPaint 'GIFf' Graphics Interchange Format 'qtif' QuickTime 'JPEG' '.SGI' 'JP2 ' JPEG 2000 'TIFF' 'META' Windows 'TPIC' Targa 'METO' Windows 'XMLO' 'moov' QuickTime Mac OS '8BPS' PhotoShop (PSD)

7 43 DELETE DELETE DELETE DELETE FROM [ WHERE { } ] WHERE WHERE DELETE DELETE FROM " " WHERE " " = 'E10001' DELETE WHERE E10001 INSERT INSERT 1 1 SELECT INSERT INSERT INTO [(,...)]VALUES (,...) [, VALUES (,...)] VALUES [4] ' 'Don''t' () INSERT INTO " " ( " ", " ", " ", " ", " ") VALUES (' ', ' ', 'E22345', 2750000, {2008/06/05}) INSERT INSERT PutAs() PutAs(col, 'type')41 CAST() GetAs()

7 44 SELECT SELECT INSERT SELECT INSERT INSERT INTO " 1" ( " ", " ", " ", " ", " ") SELECT " ", " ", " ", " ", " " FROM " " WHERE " " = ' ' INSERT SELECT INSERT SELECT SELECT INSERT INSERT/UPDATE ODBC JDBC SELECT INSERT SELECT UPDATE UPDATE UPDATE UPDATE SET =,...[ WHERE { } ] ' 'Don''t' () WHERE UPDATE UPDATE " " SET " " =32000, " " =1 WHERE " " = 'E10001' UPDATE WHERE E10001 UPDATE " " SET " " = (SELECT avg( " " ) from " " ) WHERE " " = 'E10001' E10001 UPDATE PutAs() PutAs(col, 'type')41 CAST() GetAs()

7 45 CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE ( [,...]) 1 100 1 [DEFAULT ][UNIQUE][NOT NULL] [EXTERNAL [SECURE OPEN ]] 1 [4] 1 NUMERICDECIMALINTDATETIMETIMESTAMP VARCHARCHARACTER VARYINGBLOBVARBINARYLONGVARBINARY BINARY VARYINGNUMERIC DECIMAL DECIMAL(10,0)TIME TIMESTAMP TIMESTAMP(6)VARCHAR CHARACTER VARYING VARCHAR(255) 1 DEFAULT USERUSERNAMECURRENT_USERCURRENT_DATECURDATE CURRENT_TIMECURTIMECURRENT_TIMESTAMP CURTIMESTAMP 1 UNIQUE FileMaker [ ] 1 NOT NULL FileMaker [ ] FileMaker Pro [ ] [ ] [ ] 1 BLOBVARBINARY BINARY VARYING 1 EXTERNAL FileMaker FileMaker Pro [ ] SECURE OPEN FileMaker NOT NULL SQL CREATE TABLE "T1" ("C1" VARCHAR, "C2" VARCHAR (50), "C3" VARCHAR (1001), "C4" VARCHAR (500276)) CREATE TABLE "T1NN" ("C1" VARCHAR NOT NULL, "C2" VARCHAR (50) NOT NULL, "C3" VARCHAR (1001) NOT NULL, "C4" VARCHAR (500276) NOT NULL) CREATE TABLE "T2" ("C1" DECIMAL, "C2" DECIMAL (10,0), "C3" DECIMAL (7539,2), "C4" DECIMAL (497925,301)) CREATE TABLE "T3" ("C1" DATE, "C2" DATE, "C3" DATE, "C4" DATE)

7 46 SQL CREATE TABLE "T4" ("C1" TIME, "C2" TIME, "C3" TIME, "C4" TIME) CREATE TABLE "T5" ( "C1" TIMESTAMP, "C2" TIMESTAMP, "C3" TIMESTAMP, "C4" TIMESTAMP) CREATE TABLE "T6" ("C1" BLOB, "C2" BLOB, "C3" BLOB, "C4" BLOB) CREATE TABLE "T7" ("C1" BLOB EXTERNAL 'Files/MyDatabase' SECURE) CREATE TABLE "T8" ("C1" BLOB EXTERNAL 'Files/MyDatabase' OPEN 'Objects') ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ADD [COLUMN] ALTER TABLE DROP [COLUMN] ALTER TABLE ALTER [COLUMN] SET DEFAULT ALTER TABLE ALTER [COLUMN] DROP DEFAULT ALTER TABLE SQL ALTER TABLE " " ADD " 1" VARCHAR ALTER TABLE " " DROP " 1" ALTER TABLE " "ALTER " " SET DEFAULT FileMaker ALTER TABLE " " ALTER " " DROP DEFAULT SET DEFAULT DROP DEFAULT CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX ON. CREATE INDEX ON ( ) CREATE INDEX FileMaker FileMaker [ ] [ ] FileMaker [ ] [ ] FileMaker [ ] [ ]

7 47 FileMaker CREATE INDEX CREATE INDEX ON. DROP INDEX DROP INDEX DROP INDEX DROP INDEX ON. DROP INDEX ON ( ) FileMaker SELECT FileMaker [ ] [ ] [ ] PREVENT INDEX CREATION SQL DROP INDEX ON " "." " SELECT AVG(" ") AVG(" " * 1.07) DISTINCT COUNT (DISTINCT " ")

7 48 SUM AVG COUNT MAX MIN SUM AVG COUNTCOUNT COUNT COUNT(*) MAX MIN SELECT SUM (" "." ") AS " " FROM " " SELECT AVG (" "." ") AS " " FROM " " SELECT COUNT (" "." ") AS " " FROM " " SELECT MAX (" "." ") AS " " FROM " " WHERE " "." " < 300000 SELECT MIN (" "." ") AS " " FROM " " WHERE " "." " > 300000 SQL SELECT WHERE HAVING ORDER BY 1 1 1 1 1 1 1 1 1.

7 49 * 1.05 1.05 30 ' 'Don''t' FileMaker {} ODBC/JDBC 1 {D '2012-06-05'} 1 {T '14:35:10'} 1 {TS '2012-06-05 14:35:10'} FileMaker (DTTS) FileMaker SQL-92 ISO 1 DATE 'YYYY-MM-DD' 1 TIME 'HH:MM:SS' 1 TIMESTAMP 'YYYY-MM-DD HH:MM:SS' ' ' 1.05 DATE '2012-06-05' { D '2012-06-05' } {06/05/2012} {06/05/12} ODBC/JDBC SQL-92 TIME '14:35:10' { T '14:35:10' } {14:35:10} TIMESTAMP '2012-06-05 14:35:10' { TS '2012-06-05 14:35:10'} {06/05/2012 14:35:10} {06/05/12 14:35:10} FileMaker [ 4 ] ODBC/JDBC SQL-92 SELECT "column1" / 3.4E+7 FROM "table1" WHERE "calc" < 3.4E-6 * "column2"

7 50 +-*/ ^ ** +- + + ' ' - - ' ' {D '2008-30-01'} + + 5 {D '2008-02-04'} - - {D '2008-01-01'} - 10 29 {D '2008-01-20'} SELECT " ", " " + 30 AS " " FROM " " SELECT " ", " " - 30 AS " " FROM " " = <> > >= < <= LIKE NOT LIKE IS NULL

7 51 IS NOT NULL BETWEEN IN NOT IN EXISTS ANY ALL =<>>>=< <= =Any In =<>>>=< <= SELECT " "." " FROM " " WHERE " "." " = 'SP-1' SELECT " "." " FROM " " WHERE " "." " <> 125 SELECT " "." " FROM " " WHERE " "." " > 300000 SELECT " "." " FROM " " WHERE " "." " < '12:00:00' SELECT " "." " FROM " " WHERE " "." " LIKE '% ' SELECT " "." " FROM " " WHERE " "." " NOT LIKE '% ' SELECT " "." " FROM " " WHERE " "." " IS NULL SELECT " "." " FROM " " WHERE " "." " IS NOT NULL SELECT " "." " FROM " " WHERE " "." " BETWEEN 1 AND 10 SELECT COUNT(" "." ") AS " " FROM " " WHERE " "." " IN (50,250,100) SELECT COUNT(" "." ") AS " " FROM " " WHERE " "." " NOT IN (50,250,100) SELECT COUNT (" "." ") AS " " FROM " " WHERE " "." " NOT IN (SELECT " "." " FROM " " WHERE " "." " = 'SP-4') SELECT * FROM " " WHERE EXISTS (SELECT " "." " FROM " " WHERE " "." " IS NOT NULL) SELECT * FROM " " WHERE " "." " = ANY (SELECT " "." " FROM " " WHERE " "." " = 'SP-1') SELECT * FROM " " WHERE " "." " = ALL (SELECT " "." " FROM " " WHERE " "." " IS NULL)

7 52 AND OR = 4000000 AND = 1 NOT NOT ( = 4000000 AND = 1) SELECT * FROM " " WHERE " "." " NOT LIKE '% ' AND " "." " > 300000 SELECT * FROM " " WHERE (" "." " LIKE '% ' OR " "." " > 300000) AND " "." " = 'SP-1' FileMaker SQL

7 53 CHR ASCII CHR(67) C CURRENT_USER DAYNAME ID RTRIM RTRIM(' ABC ') ABC TRIM TRIM(' ABC ') ABC LTRIM LTRIM(' ABC') ABC UPPER UPPER('Allen'ALLEN LOWER LOWER('Allen') allen LEFT LEFT('Mattson',3Mat MONTHNAME RIGHT RIGHT(Mattson', 4) tson SUBSTR SUBSTRING SUBSTR('Conrad', 2, 3) onr SUBSTR('Conrad', 2) onrad SPACE SPACE(5) STRVAL STRVAL('Woltman') Woltman STRVAL(5 * 3) 15 STRVAL(4 = 5) False STRVAL({D '2008-12-25'}) 2008-12-25 TIME TIMEVAL USERNAME USER ID 9:49 TIME() 21:49:00 TIME() SQL CURRENT_TIME SELECT CHR(67) + SPACE(1) + CHR(70) FROM " " SELECT RTRIM(' ' + " "." ") AS " " FROM " " SELECT TRIM(SPACE(1) + " "." ") AS " " FROM " " SELECT LTRIM(' ' + " "." ") AS " " FROM " " SELECT UPPER(" "." ") AS " " FROM " " SELECT LOWER(" "." ") AS " " FROM " " SELECT LEFT(" "." ", 5) AS " " FROM " " SELECT RIGHT(" "." ", 7) AS " " FROM " " SELECT SUBSTR(" "." ", 2, 2) + SUBSTR(" "." ", 4, 2) AS " " FROM " " SELECT SUBSTR(" "." ", 2) + SUBSTR(" "." ", 4) AS " " FROM " " SELECT SPACE(2) + " "." " AS " " FROM " " SELECT STRVAL('60506') AS " " FROM " " WHERE " "." " = 1

7 54 ABS ATAN ATAN2 x y B 10 B'1001' 9 CEIL CEILING DEG DEGREES DAY DAY({d '2012/01/30'}) 30 DAYOFWEEK DAYOFWEEK({d '2004/05/01'}) 7 MOD MOD(10, 3) 1 EXP FLOOR HOUR (e) INT INT(6.4321) 6 LEN LENGTH LEN('ABC') 3 MONTH MONTH({d '2012/01/30'}) 1 LN LOG MAX MAX(66, 89) 89 MIN MIN(66, 89) 66 MINUTE NUMVAL PI RADIANS 0 pi NUMVAL('123') 123 ROUND ROUND(123,456.0) 123 ROUND(123.456,2) 123.46 ROUND(123.456, -2) 100 SECOND SIGN SIN SQRT TAN VAL - 0 VAL('123') 123

7 55 X 16 10 X'b9' 185 YEAR DAY({d '2012/01/30'}) 2012 CURDATE CURRENT_DATE CURTIME CURRENT_TIME CURTIMESTAMP CURRENT_TIMESTAMP TIMESTAMPVAL DATE TODAY 2012/11/21 DATE() 2012-11-21 DATEVAL DATEVAL('2012/01/30') 2012-01-30 DATE() SQL CURRENT_DATE 1 -+ 2 ^, ** 3 *, / 4 +, - 5 =, <>, <, <=, >, >=, Like, Not Like, Is Null, Is Not Null, Between, In, Exists, Any, All 6 Not 7 AND 8 OR WHERE " " > 4000000 OR " " > {d 2008/01/30} AND " " = 'D101' AND 2008 30 D101 4,000,000 WHERE (" " > 4000000 OR " " > {d 2008/01/30}) AND " " = 'D101' 4,000,000 2008 30 D101

7 56 ODBC ODBC 1 SQLTables - 1 SQLColumns 1 SQLColumnPrivileges 1 SQLDescribeCol 1 SQLGetTypeInfo JDBC JDBC 1 getcolumns 1 getcolumnprivileges 1 getmetadata 1 gettypeinfo 1 gettables 1 gettabletypes SQL CREATE TABLE DEC create table t ("dec" numeric) ABSOLUTE ACTION ADD ALL ALLOCATE ALTER AND ANY ARE AS ASC ASSERTION AT AUTHORIZATION AVG BEGIN BETWEEN BINARY BIT BIT_LENGTH BLOB BOOLEAN BOTH BY CASCADE CASCADED CASE CAST CATALOG CHAR

7 57 CHARACTER CHARACTER_LENGTH CHAR_LENGTH CHECK CHR CLOSE COALESCE COLLATE COLLATION COLUMN COMMIT CONNECT CONNECTION CONSTRAINT CONSTRAINTS CONTINUE CONVERT CORRESPONDING COUNT CREATE CROSS CURDATE CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR CURTIME CURTIMESTAMP DATE DATEVAL DAY DAYNAME DAYOFWEEK DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFERRABLE DEFERRED DELETE DESC DESCRIBE DESCRIPTOR DIAGNOSTICS DISCONNECT DISTINCT DOMAIN DOUBLE DROP ELSE END END_EXEC ESCAPE EVERY EXCEPT EXCEPTION EXEC EXECUTE EXISTS EXTERNAL EXTRACT FALSE FETCH FIRST FLOAT FOR FOREIGN FOUND FROM FULL GET GLOBAL GO GOTO GRANT GROUP HAVING HOUR IDENTITY IMMEDIATE IN INDEX INDICATOR INITIALLY INNER INPUT INSENSITIVE NSERT INT INTEGER INTERSECT INTERVAL INTO IS

7 58 ISOLATION JOIN KEY LANGUAGE LAST LEADING LEFT LENGTH LEVEL LIKE LOCAL LONGVARBINARY LOWER LTRIM MATCH MAX MIN MINUTE MODULE MONTH MONTHNAME NAMES NATIONAL NATURAL NCHAR NEXT NO NOT NULL NULLIF NUMERIC NUMVAL OCTET_LENGTH OF ON ONLY OPEN OPTION OR ORDER OUTER OUTPUT OVERLAPS PAD PART PARTIAL POSITION PRECISION PREPARE PRESERVE PRIMARY PRIOR PRIVILEGES PROCEDURE PUBLIC READ REAL REFERENCES RELATIVE RESTRICT REVOKE RIGHT ROLLBACK ROUND ROWID ROWS RTRIM SCHEMA SCROLL SECOND SECTION SELECT SESSION SESSION_USER SET SIZE SMALLINT SOME SPACE SQL SQLCODE SQLERROR SQLSTATE STRVAL SUBSTRING SUM SYSTEM_USER TABLE TEMPORARY THEN TIME TIMESTAMP TIMESTAMPVAL TIMEVAL TIMEZONE_HOUR TIMEZONE_MINUTE

7 59 TO TODAY TRAILING TRANSACTION TRANSLATE TRANSLATION TRIM TRUE UNION UNIQUE UNKNOWN UPDATE UPPER USAGE USER USERNAME USING USAGE USER USERNAME USING VALUE VALUES VARBINARY VARCHAR VARYING VIEW WHEN WHENEVER WHERE WITH WORK WRITE YEAR ZONE

8 FileMaker ODBC FileMaker Pro ODBC FileMaker ODBC SQL_VARCHAR FileMaker [ ] 100 FileMaker NULL SQL_DOUBLE FileMaker 10-308 10 +308 15 SQL_DATE SQL_TIME FileMaker 24 0 SQL_TIMESTAMP BLOB SQL_LONGVARBINARY SELECT CAST() GetAs() ODBC Unicode FileMaker INSERT INTO "mytable"("repfield"[3]) VALUES ('this is rep 3') SELECT "repfield"[1], "repfield"[2] FROM "mytable" FileMaker JDBC JDBC FileMaker JDBC SQL JDK 1.5 Web www.javasoft.com FileMaker JDBC SQL java.sql.types.varchar java.sql.types.double java.sql.types.date java.sql.types.time java.sql.types.timestamp java.sql.types.blob

8 61 FileMaker JDBC JDBC SQL FileMaker JDBC java.sql.types.timestamp 64 ODBC API 32 64 Windows ODBC API 64 32 64 32 64 ODBC JDBC FileMaker ODBC/JDBC ODBC 1 ODBC 1 FileMaker FileMaker xdbc Listener FileMaker ODBC FileMaker Listener [FileMaker] [FileMaker ODBC] FileMaker [FileMaker] [FileMaker ODBC] Invalid Username/Password FileMaker JDBC FileMaker JDBC SQLException 1 JDBC 1 FileMaker FileMaker xdbc Listener

8 62 FileMaker JDBC FileMaker Listener [FileMaker] [FileMaker JDBC] FileMaker [FileMaker] [FileMaker JDBC] Invalid Username/Password FileMaker

A ABS 54 ALL 51 ALTER TABLE (SQL )46 AND 52 ANY 51 ARRAY 32 ATAN2 54 ATAN 54 B BETWEEN 51 BLOB SELECT 41 B 54 C CAST 4260 CEILING 54 CEIL 54 CHR 53 CLOB 32 CREATE INDEX (SQL )46 CREATE TABLESQL 45 CURDATE 55 CURRENT_DATE 55 CURRENT_TIMESTAMP 55 CURRENT_TIME 55 CURRENT_USER 53 CURRENT USER 53 CURTIMESTAMP 55 CURTIME 55 D DATALINK 32 DATEVAL 55 DATE 55 DAYNAME 53 DAYOFWEEK 54 DAY 54 DEFAULT (SQL )45 DEGREES 54 DEG 54 DELETESQL 43 DISTINCT 37 DROP INDEX SQL 47 DSN Mac OS26 Windows23 9 E ExecuteSQL 11 EXISTS 51 EXP 54 EXTERNAL (SQL )45 F FileMaker 8 FileMaker JDBC 34 ODBC Mac OS26 ODBC Windows23 FLOOR 54 FOR UPDATESQL 40 FROMSQL 37 FULL OUTER JOIN38 G GetAs 4260 GROUP BYSQL 39 H HAVINGSQL 39 HOUR 54 I INNER JOIN38 INSERTSQL 43 INT 54 IN 51 IS NOT NULL 51 IS NULL 50 J Java JDK32 Java 29 JDBC 61 32 6 31 JDBC SPI32

64 JDBC JDBC URL 33 JDBC 33 Unicode 36 35 60 32 36 56 JDBC URLUniform Resource Locator33 JDBC 33 JDBC 56 L LEFT JOIN38 LEFT OUTER JOIN38 LEFT 53 LEN 54 LIKE 50 LN 54 LOG 54 LOWER 53 LTRIM 53 M Mac OS DSN 26 JDBC 29 ODBC 27 ODBC 14 MAX 54 MINUTE 54 MIN 54 MOD 54 MONTHNAME 53 MONTH 54 N NOT IN 51 NOT LIKE 50 NOT NULLSQL 45 NOT 52 NUMVAL 54 O ODBC 61 60 6 21 36 ODBC/JDBC 23 ODBC Mac OS27 ODBC Unicode 36 Mac OS27 Windows25 56 60 36 ODBC Windows26 ODBC 56 ORDER BYSQL 40 OR 52 OUTER JOIN38 P PI 54 PREVENT INDEX CREATION47 R RADIANS 54 Rapid Application Development (RAD) 31 REF 32 RIGHT JOIN38 RIGHT OUTER JOIN38 RIGHT 53 ROUND 54 RTRIM 53 S SECOND 54 SELECTSQL 37 BLOB 41 41 41 SIGN 54 SIN 54 SPACE 53 SQL_C_WCHAR 36 SQL-9236 SQLExceptions61 SQL 48 55 52 49 50 49 50 48 50 50 52 SQL 55 SQL 49 SQL 52 SQL 49 SQL 50 SQL 49

65 SQL 50 SQL 48 SQL 50 SQL 50 SQL 52 SQL ALTER TABLE46 CREATE INDEX46 CREATE TABLE45 DELETE43 DROP INDEX47 INSERT43 SELECT37 UPDATE44 36 56 SQL 47 SQL 48 SQL 36 SQL 11 SQRT 54 STRVAL 53 SUBSTRING 53 SUBSTR 53 T TAN 54 TIMESTAMPVAL 55 TIMEVAL 53 TIME 53 TODAY 55 TRIM 53 U Unicode 36 UNIONSQL 39 UNIQUE (SQL )45 UPDATE (SQL )44 UPPER 53 USERNAME 53 V VALUES SQL 43 VAL 54 W WHERESQL 38 Windows DSN 23 JDBC 29 ODBC 25 ODBC 14 X Y YEAR 55 23 23 JDBC 35 ODBC Mac OS27 ODBC Windows25 JDBC 35 ODBC Mac OS27 ODBC Windows25 40 1429 1429 61 CREATE TABLE 4546 INSERT 43 JDBC 60 ODBC 60 SELECT 41 UPDATE 44 45 QuickTime 42 42 42 JDBC32 ODBC40 FileMaker ODBC JDBC 6 23 23 SELECT 41 SQL56 ODBC/JDBC 23 FileMaker 8 X 55

66 50 FileMaker 6 60 38 56 27 43 49 1429 32 32 8 49 JDBC 35 JDBC 34 ODBC Mac OS27 ODBC Windows25 ODBC Mac OS26 ODBC Windows23 FileMaker DSN9 FileMaker 8 DSN JDBC 60 ODBC 60 DSN25 8 3738 SQL47 9 JDBC 34 ODBC Mac OS26 ODBC Windows23 4360 9 SELECT 41 JDBC34 ODBC2528 49 36 8 23 42 JDBC 60 ODBC 60 45 36 JDBC 30 32 DSN2427 53 SQL 56 8 11 37 43 23 32