Connection context

OpenSwitch tracks and restores database context changes per incoming user connections provided that the context changes are made using remote procedure calls (RPCs) or a language call (an explicit USE statement). It does not, however, track and restore current character set or language context for a given connection, if the context is changed following the initial connection. This may affect multilingual environments.

Additionally, OpenSwitch cannot track and restore other connection-based context information stored within Adaptive Server, such as session settings. For example, a connection that has issued a SET SHOWPLAN ON option resets to OFF following an OpenSwitch switch request. However, when these options are set programmatically via dboption() or ct_options(), they are properly restored following a switch request.