Back to results
US 6,189,010 B1Granted
Method for repairing constraint violations in a database management system
AssigneePlatinum Technology, Inc.
InventorAmando B. Isip, Jr.
Life of this patent
Estimating the term…
Abstract
In response to a constraint violation in a row of a database table, an output file is generated including the characteristics of the table containing the row in error as well as an SQL UPDATE statement for the row. The SQL UPDATE statement includes the column values in the row which can be corrected by the user, the user modified SQL UPDATE statement being subsequently executed to repair the constraint violation.
Claims18
A method for repairing a constraint violation in a database table, comprising the steps of:
- generating an output file for a database table, the database table containing a row including a constraint violation;
- and
- generating an update statement for the row including the constraint violation, the update statement being stored in the output file and including a current value for predetermined columns of the row, each current value being modifiable to repair the constraint violation.
A method for repairing a constraint violation in a database table, comprising the steps of:
- generating an output file for a database table containing a row having a constraint violation;
- and
- generating an update statement for the row containing the constraint violation, the update statement being stored in the output file and including a current value of the row causing the constraint violation.
Dependencies are inferred from the claim text.