DEFAULT_SQLLEVEL built-in global variable

The DEFAULT_SQLLEVEL global variable contains the value of the default value of the SQLLEVEL SQL processing option (DECPSQLL).

This DEFAULT_SQLLEVEL global variable has the following characteristics:
  • It is read only, with values maintained by the system.
  • The type is VARCHAR(30)
  • The schema is SYSIBM.
  • The scope of this global variable is session.

The format is VvvRrMmmm, where vv is the version, r is the release, and mmm is the modification level. For example, V13R1M506 identifies function level 506. For a list of all available function levels in Db2 13, see Db2 13 function levels.