The following SQL Reference is provided to you courtesy of Elevate Software, the manufacturer of DBISAM – the database engine used by Alventis. We are including the Reference almost verbatim, so don't be surprised to see numerous and as yet unfamiliar references to DBISAM. It is simply the engine ticking under the hood of Alventis. Note also that all references to "full text indexing" in the SQL Reference have nothing to do with the likewise-named feature of Alventis. Alventis does not use DBISAM's full text indexing (it uses a separate Rubicon engine to achieve a similar effect). We chose to include all information for the sake of completeness – even though you are likely to only ever need a small subset thereof.
DBISAM does not support the complete ANSI SQL-92 specification. Rather, it supports a subset of the specification that includes the most widely used SQL statements for data manipulation and definition, in some cases with DBISAM extensions, as well as some SQL statements that are specific to DBISAM:
|SELECT||SQL-92 with DBISAM Extensions|
|INSERT||SQL-92 with DBISAM Extensions|
|UPDATE||SQL-92 with DBISAM Extensions|
|DELETE||SQL-92 with DBISAM Extensions|
|COMMIT||SQL-92 with DBISAM Extensions|