Computer Associates Think, Inc.

Wayne Joseph Barbarek

James Lawrence Broadhurst

A system and method includes steps or acts of: organizing table partitions in logical order; presenting the partition table numbers and their current ending values in logical order to a user; receiving an alter command from the user, the alter command specifying at least one logical partition number and its corresponding ending value; internally matching the specified logical partition number to its corresponding physical partition number; altering the physical partitioning of the table by manipulating one or more current ending values of partitions by altering the current ending value of the physical partition to which the specified logical partition is associated, such that new ending values are generated; and automatically generating at least one data definition language statement corresponding to the alter command, using the new ending value.

System and method for safely automating the generation of multiple data definition language statements

In one embodiment, a method includes receiving a request to perform a task using a special character. The method further includes receiving from a user an indication specifying an interpretation of the special character and storing the indication. The method further includes interpreting the special character using the indication, and performing the task using the interpreted special character.

System and method for indicating special characters to be interpreted literally

A method for facilitating creation and managing of partitioned table indices of a table object of a first partitioning type includes steps of: automatically looking up a table and its partitioning type definition; retrieving the table index and all indices defined for that table object, and their definitions; presenting to a user at least a portion of the table index in a single set of index alter screens; receiving from the user an alter request in the form of a screen option; performing validity checking on the screen option, based on the index type. If the screen option is not compatible with the index type, the method automatically overrides the screen option with one that is compatible, and issues a diagnostic message. If the screen option is valid for the index type, the user is notified about the changes that will be made and the effect of those changes. Data definition language statements are then generated consistent with the screen options.

Method and apparatus to facilitate the creating and altering of index objects on tables

A method for converting a table object from a first partitioning type to a second partitioning type includes steps or acts of gathering information including a definition of a clustering index of the table object; converting the table object of the first partitioning type into a virtual table object of the second partitioning type by virtually applying the information to a clustering index of the table object such that the virtual table object represents how the table object will appear when it is explicitly converted; and presenting the virtual table object to a user for viewing and manipulating as a table of the second partitioning type before generating an explicit conversion to said second partitioning type.

Growing community of inventors

Chicago, IL, United States of America

Wayne Joseph Barbarek