Example 1: Set the isolation level to *ALL and the naming mode to SQL names.
EXEC SQL SET OPTION COMMIT =*ALL, NAMING =*SQL
Example 2: Set the date format to European, the isolation level to *CS, and the decimal point to the comma.
EXEC SQL SET OPTION DATFMT = *EUR, COMMIT = *CS, DECMPT = *COMMA
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.