Special registers

A special register is a storage area that is defined for an application process by Db2 and is used to store information that can be referenced in SQL statements. A reference to a special register is a reference to a value provided by the current server. If the value is a string, its CCSID is a default CCSID of the current server.

The special registers can be referenced as follows:

Read syntax diagramSkip visual syntax diagramCURRENT ACCELERATORCURRENT APPLICATION COMPATIBILITYCURRENT APPLICATION ENCODING SCHEMECURRENT CLIENT_ACCTNGCURRENT CLIENT_APPLNAMECURRENT CLIENT_CORR_TOKENCURRENT CLIENT_USERIDCURRENT CLIENT_WRKSTNNAMECURRENT DATECURRENT_DATE1CURRENT DEBUG MODECURRENT DECFLOAT ROUNDING MODECURRENT DEGREECURRENT EXPLAIN MODECURRENT GET_ACCEL_ARCHIVECURRENTLOCALELC_CTYPECURRENT_LC_CTYPECURRENT MAINTAINEDTABLETYPESFOR OPTIMIZATIONCURRENT MEMBERCURRENT OPTIMIZATION HINTCURRENT PACKAGE PATHCURRENT PACKAGESETCURRENT PATHCURRENT_PATHCURRENT PRECISIONCURRENT QUERY ACCELERATIONCURRENT QUERY ACCELERATION WAITFORDATACURRENT REFRESH AGECURRENT ROUTINE VERSIONCURRENT RULESCURRENT SCHEMACURRENT_SCHEMA1CURRENT SERVERCURRENT SQLIDCURRENT TEMPORAL BUSINESS_TIMECURRENT TEMPORAL SYSTEM_TIMECURRENT TIMECURRENT_TIME1CURRENT TIMESTAMPCURRENT_TIMESTAMP1(6)(integer)WITHOUT TIME ZONEWITH TIME ZONECURRENT TIME ZONEENCRYPTION PASSWORD2SESSION TIME ZONESESSION_USERUSER
Notes:
  • 1 The SQL standard uses the form with the underline.
  • 2 The ENCRYPTION PASSWORD special register can only be explicitly referenced in the SET ENCRYPTION PASSWORD statement. It is used implicitly by the encryption and decryption functions.