Adapter for SAP/R3: Support for Strict Mode in Release 7.40 and Up

Starting with Release 7.40, SAP implemented a stricter check for and enforcement of Open SQL syntax rules:

• List elements in Open SQL statements are separated by a comma.
• Host variables in Open SQL statements are escaped by an at symbol (@).

To enable a user to control use of strict mode, the following command has been introduced.

ENGINE SQLSAP SET SQLSTRICTMODE {ON|OFF|AUTO}

where:

ON

Enforces use of strict mode, regardless of the target SAP system capabilities.

OFF

Turns off strict mode.

AUTO

Sets strict mode automatically depending on the target SAP system kernel release (Kernel 740 SP02 and higher support ON). This is the default value.

To revert to the automatic setting, issue the following command.

ENGINE SQLSAP SET SQLSTRICTMODE RESET