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_ACCTNGCLIENT ACCTNGCURRENT CLIENT_APPLNAMECLIENT APPLNAMECURRENT CLIENT_CORR_TOKENCURRENT CLIENT_USERIDCLIENT USERIDCURRENT CLIENT_WRKSTNNAMECLIENT 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_SERVERCURRENT SQLIDCURRENT TEMPORAL BUSINESS_TIMECURRENT TEMPORAL SYSTEM_TIMECURRENT TIMECURRENT_TIME1CURRENT TIMESTAMPCURRENT_TIMESTAMP1(6)(integer)WITHOUT TIME ZONEWITH TIME ZONECURRENT TIME ZONECURRENT TIMEZONECURRENT_TIMEZONESESSION TIME ZONESESSION TIMEZONESESSION_USERUSER
Notes:
  • 1 The SQL standard uses the form with the underline.