How do I specify which connection context instance and/or execution context instance a SQLJ statement should use?
Suppose you have instantiated a connection context instance connctxt and an execution context instance execctxt. Consider the following examples. #sql [connctxt] { …SQL operation…}; The preceding specifies that connctxt should be used for this statement. The default execution context instance will be used. #sql [execctxt] { …SQL operation…}; The preceding specifies that exectxt should be used for this statement. The default connection context instance will be used. #sql [connctxt, execctxt] { …SQL operation…}; The preceding specifes that connctxt and exectxt should both be used (the connection context instance must precede the execution context instance when specifying both).
