International Business Machines Corporation

Joe Cheng-yu Huang

Curt Lee Cotner

Yao-Ching Stephen Chen

Jay A Yothers

Tammie Dang

Claire Willey McFeely

Margaret Zagelow

Yumi Kimura Tsuji

Baoqiu Cui

James Willis Pickel

Manogari Nogi Simanjuntak

Margaret Ann Bernal

Chunfeng Pei

Georgia Carroll Fuller

Ding-Wei Chieh

Hui-An Lee

Liyan Zhou

Robert Thomas Miller

Marion B Farber

Xiaoyu Yang

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

Techniques are provided for supporting versions of a routine. A first version of the routine is created. A second version of the routine is generated in response to receiving an alter statement including an add version clause. The second version of the routine is activated in response to receiving an alter statement including an activate version clause.

Supporting multiple versions of a routine

Growing community of inventors

San Jose, CA, United States of America

Joe Cheng-yu Huang