Examples

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