Caroline J Huang

US Patent:

56491689, Jul 15, 1997

Filed:

Jun 7, 1995

Appl. No.:

8/475841

Inventors:

Caroline Josette Huang - San Jose CA
Yun Wang - Saratoga CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 1314
G06F 1516

US Classification:

395500

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.

US Patent:

57649499, Jun 9, 1998

Filed:

Sep 29, 1994

Appl. No.:

8/310799

Inventors:

Caroline Josette Huang - San Jose CA
Yun Wang - Saratoga CA

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 300
G06F 1700

US Classification:

395500

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.