Patent ID: 7516138

Claim:
A method for input parameter binding, comprising: at bind time, calculating and storing optimization information in a bind-in structure; when executing a statement for one of a multiple row insert and a multiple row fetch, when performing bind-in of host variables: for column array processing for local processing, comparing data in an application structure received with the statement with optimization information in the bind-in structure, wherein the optimization information includes at least one of data type, length, Coded Character Set Identifier, an array size, an indication of whether conversions are required, and an indication of whether the required conversions are valid, wherein the application structure describes data, wherein the application structure is used to store data to be retrieved for a fetch statement, and wherein the application structure is used to provide data to be inserted for an insert statement; and for stream array processing for distributed processing, comparing the optimization information in the bind-in structure with information in a stream flow that includes metadata that is sent with the data; when there is a match, executing the statement with the optimization information to perform one of fetching data from the data store and inserting data into the data store; and when there is not a match, regenerating optimization information; and executing the statement with the regenerated optimization information to perform one of fetching data from the data store and inserting data into the data store.