Query pass through in a heterogeneous, distributed database environment

Claim 3

The method of claim 1, wherein said step of handling said statement in said pass through mode is only performed if said statement is dynamic, and wherein all static statements are handled in said native mode.

Claim 4

The method of claim 1, wherein said statement falls within said scope of said pass through session if said statement is prepared and executed after said initiate statement and before said reset statement.

Claim 5

The method of claim 1, wherein said statement is outside said scope of said pass through session if said statement is prepared prior to said initiate statement.

Claim 6

The method of claim 1, further comprising the step of issuing an error if said statement is prepared within said scope of said pass through session but executed outside said scope of said pass through session.

Claim 7

The method of claim 1, further comprising the step of hardcopying a literal in place of an input host variable in a statement being handled in said pass through mode.

Claim 8

A data processing system, comprising: a first computer system, having a database instance running therein; a second computer system, having an application process running therein, said application process having statement to be executed by said database instance; an interface module, configured to interface said first computer system with said second computer system and to pass said statement to said database instance for execution; first means for defining a scope of a pass through session using an initiate statement to establish said pass through session and a reset statement to terminate said pass through session; second means for handling said statement in a pass through mode if said statement fall within said scope of said pass through session; and third means for handling said statement in a native mode if said statement is outside of said scope of said pass through session; wherein statements received subsequent to said initiate statement and prior to said reset statement are handled in said pass through mode; and wherein said statement is not processed by said first computer system in pass through mode.

Claim 9

A data processing system, comprising: a first computer system, having a database instance running therein; a second computer system, having an application process running therein, said application process having statement to be executed by said database instance; an interface module, configured to interface said first computer system with said second computer system and to pass said statement to said database instance for execution; first means for defining a scope of a pass through session using an initiate statement to establish said pass through session and a reset statement to terminate said pass through session; second means for handling said statement in a pass through mode if said statement fall within said scope of said pass through session; and third means for handling said statement in a native mode if said statement is outside of said scope of said pass through session; wherein statements received subsequent to said initiate statement and prior to said reset statement are handled in said pass through mode; and wherein said statement is not processed by said first computer system in pass through mode.

Claim 10

The data processing system of claim 7, further comprising means for handling all static statements in said native mode.

Claim 11

The data processing system of claim 7, further comprising means for issuing an error if said statement is prepared within said scope of said pass through session but executed outside said scope of said pass through session.

Claim 12

The data processing system of claim 7, further comprising means for hardcopying a literal in place of an input host variable in a statement being handled in said pass through mode.

Claim 13

A computer system, comprising: a plurality of database servers, each having processor and a RAM, and adapted to support one or more database instances; one or more client servers, each having a processor and a RAM, and tuning an application program; and an interface module, having a processor and a RAM, and running an interface module application to interface said database servers to said client servers; wherein at least one of said database instances is adapted to support application program syntax not supported by said interface module application and wherein said interface module provides a pass through capability to pass said syntax to said at least one of said database instance, said interface module further comprising: first means for defining a scope of a pass through session using an initiate statement to establish said pass through session and a reset statement to terminate said pass through session; second means for handling said statement in a pass through mode if said statement falls within said scope of said pass through session; and third means for handling said statement in a native mode if said statement is outside of said scope of said pass through session, wherein statements received subsequent to said initiate statement and prior to said reset statement are handled in said pass through mode; and wherein said statement is not processed in pass through mode.

Claim 14

A computer system, comprising: a plurality of database servers, each having processor and a RAM, and adapted to support one or more database instances; one or more client servers, each having a processor and a RAM, and tuning an application program; and an interface module, having a processor and a RAM, and running an interface module application to interface said database servers to said client servers; wherein at least one of said database instances is adapted to support application program syntax not supported by said interface module application and wherein said interface module provides a pass through capability to pass said syntax to said at least one of said database instance, said interface module further comprising: first means for defining a scope of a pass through session using an initiate statement to establish said pass through session and a reset statement to terminate said pass through session; second means for handling said statement in a pass through mode if said statement falls within said scope of said pass through session; and third means for handling said statement in a native mode if said statement is outside of said scope of said pass through session, wherein statements received subsequent to said initiate statement and prior to said reset statement are handled in said pass through mode; and wherein said statement is not processed in pass through mode.

Claim 15

The computer system of claim 11, wherein said interface module further comprises means for handling all static statements in said native mode.

Claim 16

The computer system of claim 11, wherein said interface module further comprises means for issuing an error if said statement is prepared within said scope of said pass through session but executed outside said scope of said pass through session.

Claim 17

The computer system of claim 11, wherein said interface module further comprises means for hardcopying a literal in place of an input host variable in a statement being handled in said pass through mode.

Claim 18

An interface module for interfacing a client server running an application program to one or more data base servers, comprising; first means for defining a scope of a pass through session using an initiate statement to establish said pass through session and a reset statement to terminate said pass through session; second means for handling said statement in a pass through mode if said statement falls within said scope of said pass through session; and third means for handling said statement in a native mode if said statement is outside of said scope of said pass through session; wherein statements received subsequent to said initiate statement and prior to said reset statement are handled in said pass through mode; and wherein said statement is not processed in pass through mode.

Claim 19

An interface module for interfacing a client server running an application program to one or more data base servers, comprising; first means for defining a scope of a pass through session using an initiate statement to establish said pass through session and a reset statement to terminate said pass through session; second means for handling said statement in a pass through mode if said statement falls within said scope of said pass through session; and third means for handling said statement in a native mode if said statement is outside of said scope of said pass through session; wherein statements received subsequent to said initiate statement and prior to said reset statement are handled in said pass through mode; and wherein said statement is not processed in pass through mode.

Claim 20

The interface module of claim 15, further comprising means for handling all static statements in said native mode.

Claim 21

The interface module of claim 15, further comprising means for issuing an error if said statement is prepared within said scope of said pass through session but executed outside said scope of said pass through session.

Claim 22

The interface module of claim 15, further comprising means for hardcopying a literal in place of an input host variable in a statement being handled in said pass through mode.