International Business Machines Corporation

Judianto Sidik

I-Shin Andy Wang

Frederick Thomas Sharp

John Shek-Luen Ng

Shu-Huar Joseph Yeh

John Luen Ng

Rita S Wu

Paul Chun-Hong Leung

Jay William Warfield

David Y Chen

Morgan Young

A method and apparatus for generating a Common Gateway Interface (CGI) adaptor customized for a stored procedure. In accordance with the present invention, stored procedure application developers can provides their stored procedure to a builder, which creates a CGI adaptor customized for the stored procedure. To generate the CGI adaptor, the builder parses the stored procedure to identify the arguments of the stored procedure. Then, using the stored procedure arguments, the builder generates logic to extract variables from an input data stream, wherein the variables correspond to the arguments of the stored procedure. The builder also generates logic to invoke the stored procedure using the variables extracted from the input data stream. The generated logic comprises the customized CGI adaptor.

Generating a common gateway interface adaptor customized for a stored

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

Generating a common gateway interface adapter customized for a stored

A system and method for building and linking an interpretive procedure so as to enable a compiled computer program to invoke the interpretive procedure are described herein. A target object code is modified to include information identifying files associated with the interpretive procedure. A compiled representation of the interpretive procedure is generated by linking together adapter code, the modified target object code, and an interpreter. The compiled representation of the interpretive procedure is invocable by a compiled computer program. The adapter code is in binary and includes an interpreter command module. The interpreter command module when executed causes the interpreter to load and interpretively execute the files associated with the interpretive procedure. The adapter code also includes a parameter conversion module, which converts the parameter list to the interpretive computer language of the interpretive procedure.

System and method for enabling a compiled computer program to invoke an

A system and method for transferring a file from a client platform to a server platform. A procedure.sub.-- to.sub.-- invoke parameter is set equal to information identifying a file transfer procedure located at the server platform. A pointer in a first 'sqlvar' parameter is caused to point to the string representing the file, and a pointer in a second sqlvar parameter is caused to point to a file name of the file. The first and second sqlvar parameters are part of an input.sub.-- args parameter. A 'sqleproc' function is invoked at the client platform. The procedure.sub.-- to.sub.-- invoke and input.sub.-- args parameters are passed to the sqleproc function. The sqleproc function when executed causes the input.sub.-- args parameter to be passed to the file transfer procedure at the server platform, and also causes the file transfer procedure to be invoked at the server platform.

Platform-transparent registration and build of stored procedures and

Growing community of inventors

San Jose, CA, United States of America

Judianto Sidik