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 use to access data. 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. Because AcuSQL complies with the ISO/ANSI SQL 92 standard, it is not within the scope of this document to explain these standard SQL verbs. In order to understand which SQL features your database supports, be sure to work with a knowledgeable database administrator.
More: