John Walter Moore - Coppell TX, US Richard Bruce Gough - Richardson TX, US Jared Moran - Frisco TX, US Joseph Wenger - Grapevine TX, US
Assignee:
CA, Inc. - Islandia NY
International Classification:
G06F 7/00 G06F 17/00
US Classification:
707625
Abstract:
Methods and systems for updating a database with one or more update records are provided in the present application. A staged table corresponding to a primary table of the database is generated. The update record is processed to validate the update record to determine whether there is an error in the update record and to add the update record to the staged table. The update record is copied from the staged table to the primary table when there is no error in the update record. The update record is deleted from the staged table after the update record is processed.