Appendix B: SQL Support

This appendix lists the SQL statements, commands, and functions supported by the Synergy database driver (vtx4), and documents how they are implemented for xfODBC. Statements, commands, and functions that are not listed are not supported. Note that this is not intended as a general guide to SQL.

Examples in this section that use the Customers, Orders, Plants, and Vendors tables are written for the sample database included in the Connectivity Series distribution. For information on setting up this database for xfODBC access, see Using the Sample Database As a Tutorial.


We strongly recommend that you do not use ODBC to update Synergy data. See Statements that modify data for notes on updating databases.

Conventions, names, and identifier case

Statements that access data

Restrictions to xfODBC’s support of SQL

Notes on clauses, columns, and aliases

Aggregate functions

Scalar functions

Bitwise functions

Statements that modify data

Statements that define the schema (DDL)

Statements that set options

ODBC reserved words