International Business Machines Corporation

John Luen Ng

Frederick Thomas Sharp

I-Shin Andy Wang

Judianto Sidik

Jin-Fan Shaw

Michael Lai

A method, apparatus, and article of manufacture for passing a VisualBasic array argument to an SQL stored procedure executed by a computer. The VisualBasic array is first created in the memory of the computer and comprises an object. The array is then passed to a C or C++ function in the memory of the computer. The function to which the array is passed is declared as an alias for another function within VisualBasic. Execution of the function by the computer returns a handle for the passed array. Finally, the handle is passed to the SQL stored procedure in the memory of the computer, and is accessed by the stored procedure during execution by the computer.

Passing arrays to stored procedures

A subscript table mapping system for optimizing the compilation of certain Fortran 90 array construction and array manipulation transformation functions. The subscript table data object of this invention is used to perform the three compiler optimizations, including subscript dependency analysis, subscript table transformation and optimized code generation. Application of a simple subscript mapping function tailored to the particular intrinsic Fortran 90 array variable transformation function permits compilation of executable binary code that saves substantial processing steps and data storage space by avoiding during execution the usual requirement for temporary storage of abstract transformational array variables.

Growing community of inventors

San Jose, CA, United States of America

John Luen Ng