Abstract: Provided are techniques for static execution of statements. Information from an execution file that describes statements that have been bound to a database during a previous execution of those statements dynamically and describes metadata about the statements is loaded. While executing a program that includes statements, for each of the statements, it is determined whether that statement is bound to the database. In response to determining that the statement is bound to the database, the statement is executed statically using the loaded information. In response to determining that the statement is not bound to the database, the statement is executed dynamically.

Abstract: Systems, methods and articles of manufacture are disclosed for batching heterogeneous database commands. The heterogeneous database commands may include at least two database command types. Further, at least two of the heterogeneous database commands may include host variables. A request to execute the heterogeneous database commands may be received. The heterogeneous database commands may be sent to a database system for execution, responsive to the request.

Abstract: Embodiments of the invention provide coverage analysis of database elements accessed by a software application, thus providing improved and more complete testing of database-aware applications. In one embodiment, database elements accessed by the software application are determined during a run-time test of the software application.

Abstract: A method of accessing layers in a multi-layer software architecture including a first layer, a second layer, and a third layer. The method includes: at the third layer, publishing an interface; and at the first layer, before execution of a first function, registering a callback routine with the third layer using the interface.

Abstract: A method and a computer program product for managing user-configurable variables are provided. The method and the computer program product provide for defining a plurality of user-configurable variables in a computer program, providing an interface operable to be utilized in the computer program for each of the plurality of user-configurable variables, creating an instance of the interface in the computer program for each of the plurality of user-configurable variables, incorporating code for implementing each of the plurality of user-configurable variables into at least one method in the instance of the interface created for the user-configurable variable, and defining a function in the computer program operable to configure any of the plurality of user-configurable variables according to a provided user specification.

Abstract: Provided are a method, system, and article of manufacture for generating information on database queries in source code into object code compiled from the source code. Source code including query statements to perform operations with respect to a database is translated into executable object code. A statement descriptor for at least one query statement is generated into the object code, wherein the statement descriptor for the at least one query statement includes information on the query statement including the query statement in the source code. The statement descriptors in the object code are processed to output information on the query statements indicated in the statement descriptors.

Abstract: Provided are techniques for generating a result set. A statement that includes at least one statement pattern is received, wherein each statement pattern is a template that indicates how a statement is to be modified for execution against a data store and wherein each statement pattern modifies program logic and control flow. Each statement pattern is expanded to generate one or more new statements, wherein each statement pattern is capable of being expanded to zero or more statement patterns. The one or more new statements are executed against a data store to obtain a result set. It is determined whether to modify the result set based on the at least one statement pattern. In response to determining that the result set is to be modified, modifying the result set.

Abstract: Systems, methods and articles of manufacture are disclosed for batching heterogeneous database commands. The heterogeneous database commands may include at least two database command types. Further, at least two of the heterogeneous database commands may include host variables. A request to execute the heterogeneous database commands may be received. The heterogeneous database commands may be sent to a database system for execution, responsive to the request.

Abstract: Provided are techniques for storing data. Invocation of a data access service is received, wherein the invocation identifies a data structure storing one or more data elements having a data format. An update handler to be plugged into a data access framework is identified, wherein the update handler processes data elements having the data format. Under control of the update handler, data elements are accessed in the data structure; one or more statements for storing the data elements into the data store are determined; and the one or more statements are forwarded to the data access framework.

Abstract: A method of accessing layers in a multi-layer software architecture including a first layer, a second layer, and a third layer. The method includes: at the third layer, publishing an interface; and at the first layer, before execution of a first function, registering a callback routine with the third layer using the interface.

Abstract: Embodiments of the invention provide coverage analysis of database elements accessed by a software application, thus providing improved and more complete testing of database-aware applications. In one embodiment, database elements accessed by the software application are determined during a run-time test of the software application.

Abstract: Provided are techniques for static execution of statements. Information from an execution file that describes statements that have been bound to a database during a previous execution of those statements dynamically and describes metadata about the statements is loaded. While executing a program that includes statements, for each of the statements, it is determined whether that statement is bound to the database. In response to determining that the statement is bound to the database, the statement is executed statically using the loaded information. In response to determining that the statement is not bound to the database, the statement is executed dynamically.

Abstract: Provided are techniques for generating a result set. A statement that includes at least one statement pattern is received, wherein each statement pattern is a template that indicates how a statement is to be modified for execution against a data store and wherein each statement pattern modifies program logic and control flow. Each statement pattern is expanded to generate one or more new statements, wherein each statement pattern is capable of being expanded to zero or more statement patterns. The one or more new statements are executed against a data store to obtain a result set. It is determined whether to modify the result set based on the at least one statement pattern. In response to determining that the result set is to be modified, modifying the result set.

Abstract: Provided are a method, system, and article of manufacture for generating information on database queries in source code into object code compiled from the source code. Source code including query statements to perform operations with respect to a database is translated into executable object code. A statement descriptor for at least one query statement is generated into the object code, wherein the statement descriptor for the at least one query statement includes information on the query statement including the query statement in the source code. The statement descriptors in the object code are processed to output information on the query statements indicated in the statement descriptors.

Abstract: Provided are techniques for storing data. Invocation of a data access service is received, wherein the invocation identifies a data structure storing one or more data elements having a data format. An update handler to be plugged into a data access framework is identified, wherein the update handler processes data elements having the data format. Under control of the update handler, data elements are accessed in the data structure; one or more statements for storing the data elements into the data store are determined; and the one or more statements are forwarded to the data access framework.

Abstract: A method and a computer program product for managing user-configurable variables are provided. The method and the computer program product provide for defining a plurality of user-configurable variables in a computer program, providing an interface operable to be utilized in the computer program for each of the plurality of user-configurable variables, creating an instance of the interface in the computer program for each of the plurality of user-configurable variables, incorporating code for implementing each of the plurality of user-configurable variables into at least one method in the instance of the interface created for the user-configurable variable, and defining a function in the computer program operable to configure any of the plurality of user-configurable variables according to a provided user specification.