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.