Methods, systems, and media for handling errors in script files

Details Methods, systems, and media for handling errors in script files Methods, systems, and media for handling errors in script files

2007-10-16

2007-10-16

Kindred, Alford W (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

10835107

ABSTRACT:
Methods, systems, and media are disclosed for handling errors resulting in error messages while executing a script file such as a Sequential Query Language (SQL) script. Embodiments may include one or more databases such as databases interconnected via a network, which include or have the ability to create and/or execute script files with on-error statements. Script files with on-error statements may include an error identifier and a resolution identifier. Each error identifier may identify one or more errors associated with the resolution identifier and the resolution identifier may identify a way to handle the error. Resolution identifiers may provide one or more error-recovery statements, calls for execution of a stored procedure, or other functions to correct, log, or ignore errors and continue or terminate execution of script files. Many embodiments include a command line processor that can recognize and implement the on-error statements.

REFERENCES:
patent: 2002/0188584 (2002-12-01), Ghannam et al.
patent: 2003/0058277 (2003-03-01), Bowman-Amuah
patent: 2003/0105732 (2003-06-01), Kagalwala et al.
patent: 2003/0229620 (2003-12-01), Carlson et al.
patent: 2004/0254948 (2004-12-01), Yao
patent: 2005/0193269 (2005-09-01), Haswell et al.
McArdle, James M., “SQL Ignore Error Feature”, IP.com Prior Art Database (https://priorart.ip.com) (document No. IPCOM000016793D) (Jul. 15, 2003 UTC) (disclosed by IBM) (Main web page http://www.ip.com).

Affiliated with

Also associated with

Rating

Methods, systems, and media for handling errors in script files does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Methods, systems, and media for handling errors in script files, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Methods, systems, and media for handling errors in script files will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3902131