International Business Machines Corporation

Georgia Carroll Fuller

Curt Lee Cotner

James Willis Pickel

Tammie Dang

Paul Miller Bird

William Robert Bireley

Margaret Ann Dong

Margaret Ann Bernal

Frankie K Sun

Michelle D Lam

Yao-Ching Stephen Chen

Julie Ann Watts

Kalpana Shyam

Jay A Yothers

Paramesh Sampatrai Desai

Claire Willey McFeely

Christopher John Crone

Peter Hoa

Yumi Kimura Tsuji

Eric N Katayama

Margaret Zagelow

Chunfeng Pei

Ding-Wei Chieh

Joe Cheng-yu Huang

William Y Kyu

Baoqiu Cui

Hui-An Lee

Liyan Zhou

Jennifer Wha-Yuh Ou

Marion B Farber

Baoqui Cui

Yumi Kimara Tsuji

Joe Cheung-Yu c/oIBM Uk Ltd Ip Law Huang

In a system for avoiding section collision for application server requests over a single database connection, the database server assigns query identifiers to each instance of the same cursor opened for the same processing level within an application, allowing multiple instances of the same cursor to be processed in parallel without section collision. The application server assigns a command source identifier to each statement sent over a single database connection to uniquely identify the application source of the statement. This applies for multiples of the same statement sent by different application sources within the same application, for a single statement containing multiple application sources, and for multiple statements from different applications multiplexed over a single database connection. These statements can be processed separately from and in parallel with the each other without section collision.

Computer-readable medium to multiplex multiple application server requests over a single database connection

An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated optimization results to regenerate run-time instructions for query statements of the database request component and make the query statements function with a deployed procedural logic component. The system maintains an association between the procedural logic component and the database request component during deployment. The system copies an internal representation of the procedural logic component to the target system without regeneration. The system regenerates the database request component to recreate the query procedure on the target system and to maintain a consistent interface between the procedural logic component and database request component.

System and method for deploying an SQL procedure

In a method for avoiding section collision for application server requests over a single database connection, the database server assigns query identifiers to each instance of the same cursor opened for the same processing level within an application, allowing multiple instances of the same cursor to be processed in parallel without section collision. The application server assigns a command source identifier to each statement sent over a single database connection to uniquely identify the application source of the statement. This applies for multiples of the same statement sent by different application sources within the same application, for a single statement containing multiple application sources, and for multiple statements from different applications multiplexed over a single database connection. These statements can be processed separately from and in parallel with the each other without section collision.

Method and mechanism to multiplex multiple application server requests over a single database connection

Provided is a method, system, program, and data structures for making data available to an application program. A result table is generated including rows corresponding to a subset of rows in a base table having data in one or more columns that satisfy a query predicate clause. The result table includes, for each row, a location identifier of the corresponding row in the base table and a column for each column in a query select list. The result table is accessed to return requested data from the base table to the application program.

Method, system, and program for processing modifications to data in tables in a database system

Growing community of inventors

San Jose, CA, United States of America

Georgia Carroll Fuller