Special Registers

Restriction: This topic applies to Windows environments only.

The XDB Server provides two special registers to store Authorization ID information. These registers can be used like column names in SQL commands.

USER

This register stores the Primary AuthID for the process. Note that if a Secondary AuthID exists for the Primary AuthID, the Secondary AuthID will appear in this register instead. If security is off, the Primary AuthID set through the Options Utility will appear in this register.

Current SQLID

This register is initially set to the value of the register USER. This register reflects the execution of a SET CURRENT SQLID command.