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

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.

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.