The ADABAS database system is compatible with ORACLE. Application programs have to be precompiled using the option 'sqlmode ORACLE'. 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 Warnung3 to ORACLE -1046
ADABAS -813 to ORACLE -1034
ADABAS -4000 to ORACLE 0
ADABAS -743 in ORACLE Warning1
Isolation level 1 or 10 is set as default. The valid isolation levels are 0, 1, 2, 3, 4.
The corresponding SQLDA structures must be included for dynamic commands in ORACLE mode. These structures are fully compatible with the ORACLE SQLDA structures, but they contain internal ADABAS information in addition. Therefore, the corresponding include files should be used which are automatically included during precompilation.
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 ORACLE mode.