Setting special registers with a profile
In Db2 11, you can now set the value of many special registers for remote applications by creating a profile in the profile tables.
You can set the value of special registers that are referenced by remote applications without changing application code. For example, you can set the level of the APPLICATION COMPATIBILITY special register to change the behavior of dynamic SQL statements without changing your application.
In applications that match the profile, special register values are set before SQL statements are run in your remote application. To set a special register, you insert into the DSN_PROFILE_ATTIBUTES table the matching PROFILEID, the KEYWORDS column value "SPECIAL_REGISTER", and the ATTRIBUTE1 column, which contains the SET special register statement.