ODBC and JDBC Developer’s Guide

Chapter 4
Supported standards
FileMaker Pro and FileMaker Server use the DataDirect 32-BIT SequeLink 5.4 drivers when hosting a
FileMaker database file as a shared data source. The ODBC client driver, when used with FileMaker
Pro or
FileMaker
Server, supports ODBC 3.5 Level 1 with some features of Level 2. The JDBC client driver, when
used with FileMaker
Pro or FileMaker Server, supports JDBC 3.0. The ODBC and JDBC client drivers
support SQL-92 entry-level conformance, with some SQL-92 intermediate features. This chapter describes the
SQL statements and constructs supported by the ODBC and JDBC client drivers, when used with
FileMaker
Pro or FileMaker Server.
Support for Unicode characters
The ODBC and JDBC client drivers support the Unicode API. However, if you’re creating a custom
application that uses the client drivers, use ASCII for field names, table names, and filenames (in case a non-
Unicode query tool or application is used).
Note To insert and retrieve Unicode data, use SQL_C_WCHAR (the SQL_C_BINARY data type is not
supported).
SQL statements and clauses
The ODBC and JDBC client drivers provide support for the following SQL statements:
The client drivers also support FileMaker data type mapping to ODBC SQL and JDBC SQL data types. See
appendix A, “Mapping FileMaker fields to ODBC data types” and appendix B, “Mapping FileMaker fields to
JDBC data types” for data type conversions. For more information on constructing SQL queries, refer to a
third-party book.
Note The ODBC and JDBC client drivers recognize only the first repetition in a repeating field. Also, the
drivers do not support portals in FileMaker
Pro.
SELECT DELETE INSERT UPDATE
CREATE TABLE ALTER TABLE CREATE INDEX DROP INDEX