The following table shows supported DB2 special registers and their HCOSS default SQL Server equivalents.
| DB2 Special Register | SQL Server Equivalent |
|---|---|
| CURRENT CLIENT_APPLNAME | APP_NAME() |
| CURRENT CLIENT_USERID | SYSTEM_USER |
| CURRENT CLIENT_WRKSTNNAME | HOST_NAME() |
| CURRENT DATE or CURRENT_DATE | CONVERT(date,SYSDATETIME()) |
| CURRENT TIME or CURRENT_TIME | CONVERT(time(0), SYSDATETIME()) |
| CURRENT TIMESTAMP or CURRENT_TIMESTAMP | CONVERT(datetime2(6), SYSDATETIME()) |
| CURRENT LC_CTYPE or CURRENT_LC_TYPE | CONVERT(char(50), SERVERPROPERTY('collation')) |
| CURRENT LOCALE LC_CTYPE | CONVERT(char(50), SERVERPROPERTY('collation')) |
| CURRENT SCHEMA or CURRENT_SCHEMA | CONVERT(varchar(128), SCHEMA_NAME()) |
| CURRENT SERVER | CONVERT(char(16), SERVERPROPERTY('servername')) |
| CURRENT SQLID | USER |
| SESSION_USER | USER |