The ADABAS database system is compatible with ANSI SQL-92 (entry level). Application programs have to be precompiled by means of the option 'sqlmode ANSI'. The sqlmode is automatically passed to the object program. Some parts of the statements which are not operative for ADABAS generate a warning ('sqlwarnf').
The sqlcode is accepted by ADABAS, except for a few cases (see the ADABAS manual Messages and Codes).
The following conversions are done:
ADABAS +250 to ANSI -250
ADABAS +300 to ANSI -300
ADABAS +320 to ANSI -320
Isolation level 3 or 30 (internal) is set as default. Valid are the isolation levels 0, 1, 2, 3, 4.
Dynamic statements with descriptors operate on the ADABAS SQLDA. The ADABAS SQLDA structure must be included for dynamic SQL in ANSI mode. This is done automatically while precompiling.
If the user wants to issue ADABAS specific statements in the application program, these have to be preceded by 'exec adabas' instead of 'exec sql'.
For a detailed description, see the ADABAS Reference manual for the ANSI mode.