Use Client Special Registers

Client special registers are a database-specific resource that can be optionally used by application providers to imprint identity or any other useful character-based detail for an application environment. Using client special registers doesn’t affect or impact the execution of SQL statements. Db2 for IBM i users can see the client special register values when using Db2 for i tools. When an application or client places meaningful values in the registers, database analysts and database administrators will have a better awareness of the application context.

(more…)