Computer program product and program storage device for including stored procedure user defined function or trigger processing within a unit of work

Claim 2

A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform method steps for incorporating an external predefined procedure into an existing unit of work, said existing unit of work being part of a client application process, said method steps comprising: (a) creating, in a database environment, a "logical representation" of said client application process, that is connected to said client application process; (b) disconnecting said "logical representation" from said client application process; (c) connecting said "logical representation" to a procedure operating environment to execute external programs; (d) executing said external predefined procedure in said procedure operating environment; (e) disconnecting said "logical representation" from said procedure operating environment; and (f). reconnecting said "logical representation" to said client application process, to incorporate the external predefined procedure into the existing unit of work.

Claim 3

The program storage device of claim 1, wherein said client application process and said procedure operating environment abruptly terminate.

Claim 4

The program storage device of claim 2, further comprising the following steps performed between steps (a) and (b) creating, in said database environment, a scaffolding agent; and connecting said scaffolding agent to said client application process, such that said scaffolding agent monitors termination of said client application process.

Claim 5

The program storage device of claim 3, further comprising the following step performed between steps (e) and (f): disconnecting said scaffolding agent from said client application process.

Claim 6

The program storage device of claim 2, wherein method step (c) comprises the method step of: modifying said logical representation such that termination of said procedure operating environment may be monitored via said logical representation.

Claim 7

The program storage device of claim 1, wherein said external predefined procedure comprises one of an external stored procedure, a user-defined function, and a trigger.

Claim 8

The program storage device of claim 1, wherein method step (d) comprises the method step of: associating all operations performed during execution of said external predefined procedure with said existing unit of work via said logical representation connected to said procedure operating environment.

Claim 9

The program storage device of claim 1, wherein method step (d) comprises the method step of: associating at least one lock created during execution of said external predefined procedure with said existing unit of work via said logical representation connected to said procedure operating environment.

Claim 10

A computer program product for use in a data processing system having a first computer system, a client application process running in the first computer system, said client application process having an in-flight unit of work, and a second computer system coupled to said first computer system, said second computer system supporting a database environment, a database system executing in said database environment, said second computer system also supporting a client application environment that cannot execute external programs, said computer product comprising: a computer usable medium having computer readable program code means embodied in said medium for causing a computer to incorporate an external predefined procedure into an existing unit of work, said existing unit of work being part of a client application process, said computer readable program code means comprising: computer program code means for creating, in said database environment, a "logical representation" of said client application process that is connected to said client application process; computer program code means for disconnecting said "logical representation" from said client application environment; computer program code means for creating a procedure operating environment in said second computer system to execute external procedures; computer program code means for connecting said "logical representation" to said procedure operating environment; computer program code means for executing an external predefined procedure in said procedure operating environment; computer program code means for disconnecting said "logical representation" from said procedure operating environment; and computer program code means for reconnecting said "logical representation" to said client application environment, thereby incorporating the external predefined procedure into the existing unit of work.

Claim 11

A computer program product for use in a data processing system having a first computer system, a client application process running in the first computer system, said client application process having an in-flight unit of work, and a second computer system coupled to said first computer system, said second computer system supporting a database environment, a database system executing in said database environment, said second computer system also supporting a client application environment that cannot execute external programs, said computer product comprising: a computer usable medium having computer readable program code means embodied in said medium for causing a computer to incorporate an external predefined procedure into an existing unit of work, said existing unit of work being part of a client application process, said computer readable program code means comprising: computer program code means for creating, in said database environment, a "logical representation" of said client application process that is connected to said client application process; computer program code means for disconnecting said "logical representation" from said client application environment; computer program code means for creating a procedure operating environment in said second computer system to execute external procedures; computer program code means for connecting said "logical representation" to said procedure operating environment; computer program code means for executing an external predefined procedure in said procedure operating environment; computer program code means for disconnecting said "logical representation" from said procedure operating environment; and computer program code means for reconnecting said "logical representation" to said client application environment, thereby incorporating the external predefined procedure into the existing unit of work.

Claim 12

The computer product of claim 9, wherein said client application process and said procedure operating environment abruptly terminate.

Claim 13

The computer program product of claim 10, wherein said computer program code means further comprises: computer program code means for creating, in said database environment, a scaffolding agent; and computer program code means for connecting said scaffolding agent to said client application process, such that termination of said client application process may be monitored via said scaffolding agent.

Claim 14

The computer program product of claim 10, wherein said computer program code means for connecting said logical representation to said procedure operating environment comprises computer program code means for modifying said logical representation such that termination of said procedure operating environment may be monitored via said logical representation.

Claim 15

The computer program product of claim 9, wherein said computer program code means for executing an external predefined procedure in said procedure operating environment comprises computer program code means for associating all operations performed during execution of said external predefined procedure with said existing unit of work via said logical representation connected to said procedure operating environment.

Claim 16

The computer program product of claim 9, wherein said first and second computer systems are implemented using a single computer platform.

Claim 17

A computer program product comprising a computer readable medium having computer program code means recorded thereon for enabling a computer system to incorporate an external predefined procedure into an existing unit of work, said existing unit of work being part of a client application process, said computer program code means comprising: computer program code means for enabling said computer system to create, in database environment, a "logical representation" of said client application process that is connected to said client application process; computer program code means for enabling said computer system to disconnect said "logical representation" from said client application process; computer program code means for enabling said computer system to connect said "logical representation" to a procedure operating environment; computer program code means for enabling said computer system to execute said external predefined procedure in said procedure operating environment; computer program code means for enabling said processor to disconnect said "logical representation" from said procedure operating environment; and computer program code means for enabling said computer system to reconnect said "logical representation" to said client application environment, thereby incorporating the external predefined procedure into the existing unit of work.

Claim 18

A computer program product comprising a computer readable medium having computer program code means recorded thereon for enabling a computer system to incorporate an external predefined procedure into an existing unit of work, said existing unit of work being part of a client application process, said computer program code means comprising: computer program code means for enabling said computer system to create, in database environment, a "logical representation" of said client application process that is connected to said client application process; computer program code means for enabling said computer system to disconnect said "logical representation" from said client application process; computer program code means for enabling said computer system to connect said "logical representation" to a procedure operating environment; computer program code means for enabling said computer system to execute said external predefined procedure in said procedure operating environment; computer program code means for enabling said processor to disconnect said "logical representation" from said procedure operating environment; and computer program code means for enabling said computer system to reconnect said "logical representation" to said client application environment, thereby incorporating the external predefined procedure into the existing unit of work.