Special literals

The syntax for special literals is as follows:

---

special_literal ::=

{
   CURRENT_CATALOG |
   CURRENT_ISOLATION_LEVEL |
   CURRENT_REFERENCED_CATALOG |
   CURRENT_SCHEMA |
   [CURRENT_]USER |
   SYSTEM_USER
}

---

CURRENT_CATALOG

Name of the database preset with the SQL statement SET CATALOG or SET SCHEMA or the *IMPLICIT string if no database is preset.
The result is a string of the type CHAR(18).

CURRENT_ISOLATION_LEVEL

Isolation level of the current transaction (defined implicitly by the user configuration or explicitly by the SQL statement SET TRANSACTION level at the beginning of a transaction). It does not specify the isolation level which is defined on a statementspecific basis with the pragma ISOLATION LEVEL.
The result is a value of the type INTEGER in accordance with the table below: .

Result	Isolation level	Consistency levels
8	SERIALIZABLE	4
4	REPEATABLE READ	3
5	READ NO WAIT	1
2	READ COMMITTED	2
1	READ UNCOMMITTED	0

CURRENT_REFERENCED_CATALOG

Name of the database to which the current statement refers.
The result is a string of the type CHAR(18).

CURRENT_SCHEMA

Name of the schema preset with the SQL statement SET SCHEMA or the *IMPLICIT string if no schema is preset.
The result is an alphanumeric string of the type VARCHAR(31).

[CURRENT_ ]USER

Name of the current authorization identifier.
The result is a string of the type CHAR(18).

SYSTEM_USER

Name of the current system user. The name is made up of the host name, the UTM application name (or blanks) and the UTM or BS2000 user ID.
The result is a string of the type CHAR(24).