Default Special Register Mappings

The default mappings HCOSS uses to convert DB2 special registers to SQL Server equivalents.

Restriction: This topic applies to Windows environments only.

Note: In addition to these default mappings, you can also define customized mappings. See Customizing Functions and Special Registers for more information.

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