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.

For examples that show how you can access and use SQL statements to query a Synergy database via xfODBC, see ODBC access examples.

Important

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

Notes on clauses, columns, and aliases

Aggregate functions

Scalar functions

Bitwise functions

Statements for managing privilege-based users and privileges

Statements that modify data

Statements that define the schema (DDL)

Statements that set options

Restrictions to xfODBC’s support of SQL

ODBC reserved words