Functional compensation in a heterogeneous, distributed database environment

A computer program product for use with a computer system, comprising:

• a computer usable medium having computer readable program code means embodied in said medium for causing the computer system to compensate for functional differences between heterogeneous database management systems, wherein data associated with a client is distributed among said heterogeneous database management systems, said computer readable program code means:
• computer readable first program code means for causing the computer system to effect a simulation of support of multiple pending database actions on a single connection, said single connection being a logical link between a client and a database instance, wherein said database instance is instantiated in any of said heterogeneous database management systems which does not support multiple pending database actions on a single connection;
• computer readable second program code mean for causing the computer system to effect a simulation of support of cursors declared "with hold" in any of said heterogeneous database management systems which does not support cursors declared "with hold";
• and
• computer readable third program code means for causing the computer system to effect a compensation for security log-in procedure differences between said heterogeneous database management systems, said computer readable third program code means comprises:
• computer readable program code means for causing the computer system to effect a reception of a local user identification and a local password when a user logs into said client;
• computer readable program code means for causing the computer system to effect a reception of a database statement issued by said client;
• computer readable program code means for causing the computer system to effect an identification of a database instance instantiated from said heterogeneous database management systems that is needed to process said database statement;
• computer readable program code means for causing the computer system to effect a determination of whether a record associated with said user and said database instance exists in a log-in table;
• computer readable program code means for causing the computer system to effect a logging on into said database instance using information contained in said record if a record associated with said user and said database instance exists in said log-in table;
• and
• computer readable program code means for causing the computer system to effect a logging on into said database instance using said local user identification and said local password if a record associated with said user and said database instance does not exists in said log-in table.