Abstract: A system and method of pass through in a heterogeneous distributed database environment allows a client to specify syntax that is only understood and processed by a database instance of a back-end server even if it is not understood by an interface module. A hybrid pass through feature provides a combination of both a pass through mode and a native mode allowing statements to be passed through to the database instance or to be processed by the interface module. To accomplish this, a pass through session is established. The scope of the pass through session is defined by statements that establish and terminate the session. Rules determine whether dynamic statements are handled in pass through mode or in native mode based on whether the statements are within or outside of the scope of the pass through session. Input host variable support is provided to database instances that don't otherwise support host variables.

Abstract: A system and method of pass through in a heterogeneous distributed database environment allows a client to specify syntax that is only understood and processed by a database instance of a back-end server even if it is not understood by an interface module. A hybrid pass through feature provides a combination of both a pass through mode and a native mode allowing statements to be passed through to the database instance or to be processed by the interface module. To accomplish this, a pass through session is established. The scope of the pass through session is defined by statements that establish and terminate the session. Rules determine whether dynamic statements are handled in pass through mode or in native mode based on whether the statements are within or outside of the scope of the pass through session. Input host variable support is provided to database instances that don't otherwise support host variables.