The SQLMODE determines which SQL dialect will be understood by the database system. The mode name is specified with the CONNECT. Usually, this is ADABAS. LOAD, however, also considers deviating entries in the XUSER file and executes all commands entered by the user as well as all INSERTs and UPDATEs generated from DATALOAD or DATAUPDATE statements in the defined mode. Command files are interpreted in the way determined by the mode.
The LOAD statement SQLMODE <mode name> can be used to change temporarily to another mode. <mode name> can assume one of the values ANSI, DB2, ORACLE, or ADABAS. The new mode is valid until it is changed by another SQLMODE statement.
Syntax:
Mode names other than the valid ones set the SQLMODE to the default ADABAS.
In ANSI mode, LOAD does not automatically conclude statements with COMMIT. If two consecutive dashes are found in a statement, the rest of the line is taken as a comment. Blank lines separate statements from each other.
In ORACLE mode, /* introduces a comment which is only terminated by */. A semicolon separates statements from each other.