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.
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
Notes on clauses, columns, and aliases
Statements for managing privilege-based users and privileges
Statements that define the schema (DDL)