PRECOMPILER SQL LEVEL field (SQLLEVEL DECP value)

Specifies the Db2 function level or release to be used by the precompiler and coprocessor for determining the allowed SQL syntax in the absence of an explicit specification of the SQLLEVEL option. Db2 also uses this parameter to set the SYSIBM.DEFAULT_SQLLEVEL built-in global variable. In most cases, set this field to the current Db2 function level.

Acceptable values: V10R1, V11R1, function-level
Default: Start of change
  • Installation: V13R1M501
  • z/OSMF migration: V13R1M501
  • Migration: value specified in the CLIST migration input member of the Db2 subsystem or first member of the data sharing group
End of change
Update: option 5 on panel DSNTIPB.
DSNZPxxx: DSNHDECP.SQLLEVEL
function-level
The precompiler and coprocessor accept only SQL syntax that is valid in a Db2 12 or later function level. The format is VvvRrMmmm, where vv is the version, r is the release, and mmm is the modification level.
V11R1 or V12R1M100
The precompiler and coprocessor accept only SQL syntax that is valid in Db2 11 new-function mode.
V10R1
The precompiler and coprocessor accept only SQL syntax that is valid in DB2® 10 new-function mode.

The function level activated on the Db2 subsystem does not restrict the SQLLEVEL value. However, you must ensure that you bind the resulting DBRM with the correct application compatibility level on a Db2 subsystem with the correct function level activated.

An online update to SQLLEVEL DECP parameter has immediate effect for the precompiler and coprocessor. However the SYSIBM.DEFAULT_SQLLEVEL built-in global variable update requires a restart of Db2.

z/OSMF migration

The SQLLEVEL DECP value is always selected as a z/OSMF variable and the setting is used to indicate the target SQLLEVEL level for Db2 after the migration process completes.