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

• US 20050256858A1
• Filed: 04/29/2004
• Published: 11/17/2005
• Est. Priority Date: 04/29/2004
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: McArdle, James Michael
• Granted Patent: US 7,283,993 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

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.

Claims

1. A method of processing a sequential query language (SQL) script with a command line processor, the method comprising:

storing an association between an error condition and an error-recovery statement based upon execution of an on-error statement in the SQL script;

determining an occurrence of the error condition, the error condition corresponding to an error message generated by the command line processor in response to the execution of the SQL script;

identifying the association between the error-recovery statement and the error condition; and

executing the error-recovery statement to resolve the occurrence of the error condition.

2. The method as in claim 1, wherein storing the association comprises generating an error-recovery table in response to execution of the on-error statement, the error message table having the error message and the error-recovery statement.

3. The method as in claim 1, wherein determining the occurrence of the error condition comprises detecting a run-time error in a SQL statement of the SQL script.

4. The method as in claim 1, wherein identifying the association comprises selecting the error-recovery statement.

5. The method as in claim 1, wherein identifying the association comprises the error-recovery statement comprises looking up the error message in an error-recovery table.

6. The method as in claim 1, wherein executing the error-recovery statement comprises ignoring the error condition.

7. The method as in claim 1, wherein executing the error-recovery statement comprises logging the error condition.

8. The method as in claim 1, wherein executing the error-recovery statement comprises removing the error condition and re-executing the SQL statement after handling the error condition.

9. A command line processor comprising:

an execution module to store an association between an error condition and an error-recovery statement based upon execution of an on-error statement in a script file and to determine an occurrence of the error condition, the error condition corresponding to an error message generated by the command line processor in response to the execution of the script file;

a logic module to identify the association between the error-recovery statement and the error condition for the script file, to select the error-recovery statement based upon the association; and

a processing module to execute the error-recovery statement to resolve the occurrence of the error condition.

10. The command line processor as in claim 9, wherein the execution module is designed to generate an error-recovery table for storing the association in response to execution of the on-error statement, the error message table having the error message and the error-recovery statement.

11. The command line processor as in claim 10, wherein the logic module searches the error recovery table for the error message to select the error-recovery statement

12. The command line processor as in claim 9, wherein the processing module ignores the error condition based upon the error-recovery statement.

13. The command line processor as in claim 9, wherein the processing module logs the error condition.

14. The command line processor as in claim 9, wherein the processing module executes the error-recovery statement to remove the error condition and re-executes a script file statement, the execution of which caused the error condition.

15. A machine-accessible medium containing instructions, which when executed by a machine, cause the machine to perform operations, comprising:

storing an association between an error condition and an error-recovery statement based upon execution of an on-error statement in a script file;

determining an occurrence of the error condition, the error condition corresponding to an error message generated by the command line processor in response to the execution of the script file;

identifying the association between the error-recovery statement and the error condition; and

executing the error-recovery statement to resolve the occurrence of the error condition.

16. The machine-accessible medium as in claim 15, wherein storing the association comprises generating an error-recovery table in response to execution of the on-error statement, the error message table having the error message and the error-recovery statement.

17. The machine-accessible medium as in claim 15, wherein determining the occurrence of the error condition comprises detecting a run-time error in a SQL statement of the script file.

18. The machine-accessible medium as in claim 15, wherein identifying the association comprises selecting the error-recovery statement.

19. The machine-accessible medium as in claim 16, wherein identifying the association comprises the error-recovery statement comprises looking up the error message in an error-recovery table.

20. The machine-accessible medium as in claim 16, wherein executing the error-recovery statement comprises ignoring the error condition.

21. The machine-accessible medium as in claim 16, wherein executing the error-recovery statement comprises logging the error condition.

22. The machine-accessible medium as in claim 16, wherein executing the error-recovery statement comprises executing the error-recovery statement to remove the error condition and re-executing a script file statement, the execution of which caused the error condition.

23. An SQL script for handling an error condition, the script comprising:

an error condition identifier to identify an error message to be generated by a command line processor in response to an error during execution of the script; and

a resolution identifier to associate the error message with an error-recovery statement, wherein execution of the error-recovery statement is designed to resolve the error condition.

24. The script of claim 23, wherein the error condition identifier comprises identifies one or more error messages.

25. The script of claim 23, wherein the resolution identifier comprises a reference to a stored procedure.

26. The script of claim 23, wherein the resolution identifier comprises an error-recovery statement to log the error condition.

27. The script of claim 23, wherein the resolution identifier comprises an error-recovery statement to ignore the error condition.

28. The script of claim 23, wherein the resolution identifier comprises an error-recovery statement to remove the error condition and to continue execution of the script.