SQL Verbs

In embedded SQL applications, two of the most vital SQL verbs are CONNECT and DISCONNECT. These are the commands that open and close communication between your application and your data source. Your data source vendor most likely recommends the CONNECT and DISCONNECT syntax to access the data source. When accessing your data source through AcuSQL, however, you should use the CONNECT and DISCONNECT syntax described below instead of the syntax recommended for your data source.

With AcuSQL, SQL data can be read (using the SELECT or FETCH statement) or written to (using the INSERT statement). Most other SQL verbs are supported as well, including, but not limited to, DELETE and UPDATE. While it is not within the scope of this document to explain these standard SQL verbs, brief introductions are provided in Sample Programs. In order to understand which SQL features your database supports, be sure to work with a knowledgeable database administrator.