Tool for converting SQL queries into portable ODBC

• US 20030041052A1
• Filed: 08/22/2001
• Published: 02/27/2003
• Est. Priority Date: 08/22/2001
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Gajda, Kimberly Lynn, Thorpe, Robert Tod, Hess, Bradley Allan
• Granted Patent: US 6,877,000 B2
• Time in Patent Office: Days
• US Class Current: 707/3
• CPC Class Codes: G06F 16/2438 Embedded query languages
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

A method, computer program product and system for converting Structured Query Language (SQL) statements into the Open Database Connectivity (ODBC) standard. The source code of a database application may be parsed to identify one or more keywords. These keywords may be used to identify SQL statements as well as variables that are used to process the SQL statements. Upon identifying the SQL statements, the SQL statements may be evaluated. The SQL statements evaluated may then be matched with particular functions in a function library, i.e., a collection of functions stored in data files. These functions may implement particular ODBC calls thereby enabling SQL statements to be converted into the ODBC standard. A function call, i.e., a call to that function, may be substituted for the corresponding SQL statement. The function call may then be implemented resulting in the execution of the ODBC calls.

Claims

1. A method for converting Structure Queried Language (SQL) queries into an Open Database Connectivity (ODBC) standard comprising the steps of:

parsing a source code to identify one or more keywords;

identifying an SQL statement based on said one or more keywords;

matching said SQL statement with a function, wherein said function is associated with one or more ODBC calls; and

substituting said SQL statement with a call to said function.

2. The method as recited in claim 1 further comprising the steps of:

identifying one or more variables based on said one or more keywords; and

building a data structure for each of said one or more variables.

3. The method as recited in claim 2 further comprising the step of:

extracting parameters from said SQL statement, wherein said parameters are data required to process said SQL statement.

4. The method as recited in claim 3 further comprising the step of:

incorporating said parameters and address of each of said data structure built in said function.

5. The method as recited in claim 1 further comprising the step of:

evaluating said SQL statement, wherein said function is matched with said SQL statement upon evaluating said SQL statement.

6. The method as recited in claim 2, wherein said data structure stores at least one of information required to process said SQL statement and a result of processing said SQL statement.

7. The method as recited in claim 1 further comprising the steps of:

compiling said source code with said call to said function substituted for said SQL statement;

executing said compiled source code; and

executing said one or more ODBC calls associated with said function.

8. The method as recited in claim 7, wherein said SQL statement requests a particular query, wherein the method further comprises the step of:

returning a result of said particular query in response to said one or more ODBC calls.

9. The method as recited in claim 8 further comprising the step of:

outputting said result.

10. A computer program product having a computer readable medium having computer program logic recorded thereon for converting Structure Queried Language (SQL) queries into an Open Database Connectivity (ODBC) standard, comprising:

programming operable for parsing a source code to identify one or more keywords;

programming operable for identifying an SQL statement based on said one or more keywords;

programming operable for matching said SQL statement with a function, wherein said function is associated with one or more ODBC calls; and

programming operable for substituting said SQL statement with a call to said function.

11. The computer program product as recited in claim 10 further comprising:

programming operable for identifying one or more variables based on said one or more keywords; and

programming operable for building a data structure for each of said one or more variables.

12. The computer program product as recited in claim 11 further comprising:

programming operable for extracting parameters from said SQL statement, wherein said parameters are data required to process said SQL statement.

13. The computer program product as recited in claim 12 further comprising:

programming operable for incorporating said parameters and address of each of said data structure built in said function.

14. The computer program product as recited in claim 10 further comprising:

programming operable for evaluating said SQL statement, wherein said function is matched with said SQL statement upon evaluating said SQL statement.

15. The computer program product as recited in claim 11, wherein said data structure stores at least one of information required to process said SQL statement and a result of processing said SQL statement.

16. The computer program product as recited in claim 10 further comprising:

programming operable for compiling said source code with said call to said function substituted for said SQL statement;

programming operable for executing said compiled source code; and

programming operable for executing said one or more ODBC calls associated with said function.

17. The computer program product as recited in claim 16, wherein said SQL statement requests a particular query, wherein the computer program product further comprises:

programming operable for returning a result of said particular query in response to said one or more ODBC calls.

18. The computer program product as recited in claim 17 further comprising:

programming operable for outputting said result.

19. A system, comprising:

a processor;

a memory unit operable for storing a computer program operable for converting Structure Queried Language (SQL) queries into an Open Database Connectivity (ODBC) standard;

an input mechanism;

an output mechanism; and

a bus system coupling the processor to the memory unit, input mechanism, and output mechanism, wherein the computer program is operable for performing the programming steps;

parsing a source code to identify one or more keywords;

identifying an SQL statement based on said one or more keywords;

matching said SQL statement with a function, wherein said function is associated with one or more ODBC calls; and

substituting said SQL statement with a call to said function.

20. The system as recited in claim 19, wherein the computer program is further operable to perform the following programming steps:

identifying one or more variables based on said one or more keywords; and

building a data structure for each of said one or more variables.

21. The system as recited in claim 20, wherein the computer program is further operable to perform the following programming step:

extracting parameters from said SQL statement, wherein said parameters are data required to process said SQL statement.

22. The system as recited in claim 21, wherein the computer program is further operable to perform the following programming step:

incorporating said parameters and address of each of said data structure built in said function.

23. The system as recited in claim 19, wherein the computer program is further operable to perform the following programming step:

evaluating said SQL statement, wherein said function is matched with said SQL statement upon evaluating said SQL statement.

24. The system as recited in claim 20, wherein said data structure stores at least one of information required to process said SQL statement and a result of processing said SQL statement.

25. The system as recited in claim 19, wherein the computer program is further operable to perform the programming steps:

compiling said source code with said call to said function substituted for said SQL statement;

executing said compiled source code; and

executing said one or more ODBC calls associated with said function.

26. The system as recited in claim 25, wherein said SQL statement requests a particular query, wherein the computer program is further operable to perform the programming step:

returning a result of said particular query in response to said one or more ODBC calls.

27. The system as recited in claim 26, wherein the computer program is further operable to perform the programming step:

outputting said result.