International Business Machines Corporation

Robert Thomas Miller

Curt Lee Cotner

Maryela Evelin Weihrauch

Yao-Ching Stephen Chen

Jay A Yothers

Tammie Dang

Claire Willey McFeely

Manogari Nogi Simanjuntak

Yumi Kimura Tsuji

Margaret Zagelow

Christopher M Farrar

Joe Cheng-yu Huang

Baoqiu Cui

Xiaoyu Yang

An apparatus, system, and method are disclosed for efficiently supporting generic SQL data manipulation statements. The method includes determining whether an SQL statement includes extended indicator parameters such as DEFAULT and UNASSIGNED indicators. The method further includes delaying an authorization check for an operation for an SQL statement using extended indicators, and bypassing an SQL exception where an otherwise unauthorized operation involves an UNASSIGNED variable. The method further includes bypassing a database operation such as a referential integrity check where a data change would induce the database operation, but the data change involves an UNASSIGNED variable. The method further includes modifying the SQL statement when the SQL statement involves an UNASSIGNED variable in a predicate clause, allowing the SQL statement to properly execute.

Apparatus, system, and method for efficiently supporting generic SQL data manipulation statements

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

Robert Thomas Miller