Special Features in SQL Mode ANSI 

·        The isolation levels 0, 1, 2, 3 are permitted in the SQL mode ANSI. The default isolation level is 3.

·        Dynamic SQL statements in ANSI mode use the SAP DB sqlda structure that is included automatically when the precompiler runs.

·        With a few exceptions, the return code sqlcode of the database system is copied from SAP DB (see Messages: SAP DB).

This table shows the exceptions and the corresponding SAP DB message codes:

ANSI Message Code	SAP DB Message Code
-250	+250
-300	+300
-320	+320
ANSISTATE 01004	sqlwarn1
ANSISTATE 01003	sqlwarn2

The warning messages sqlwarn1and sqlwarn2 appear in the structure sqlca.