US6063133A
Expired / Lapsed
US
⏱️ 0.0 years remaining
No preprocessor for embedded SQL in a 3GL
Assignee: International Business Machines Corp
•
Filing: 1998-06-30
•
Granted: 2000-05-16
•
Expires: 2018-06-30
Abstract
Abstract A system and method for translating source code, comprising high level source code with embedded SQL statements, to p-code or machine-language instructions by a one-pass parsing mechanism. The one-pass parsing mechanism generates executable code without the need to generate an intermediate file. Additionally, the p-code or machine-language instructions are annotated with references to the line numbers of the corresponding source code, thereby allowing a source level debugger to debug the source code with embedded SQL statements.
Inventors
- 👤 Chin Hsiang Li
- 👤 I-Shin-Andy Wang
- 👤 Wei Young
- 👤 Shu Huar Joseph Yeh
- 👤 John Shek-Luen Ng
- 👤 Kuo-Wei Hwang
- 👤 Mir Hamid Pirahesh
- 👤 Tak-Ming Lo
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-24 03:38
CPC Classifications
G; G06; G06F; G06F11/00; G06F11/36; G06F11/362; G06F11/3624; G06F8/00; G06F8/40; G06F8/41; G06F8/42; G06F8/427; G06F8/44; G06F8/447
Claims Analysis
Total Claims: 30
Claim 1
Independent Claim
114 words
A method for compiling source code to p-code or machine-language instructions, wherein the source code contains high-level source code with embedded SQL statements, said method comprising the steps of: reading the source code one line at a time to generate a read line of source code; determining whether said read line of source code is high level source code or an SQL statement; and compiling said read line of source code to p-code or machine-language instructions, wherein if said read line of source code is an SQL statement, said compilation of said read line of source code occurs in a one-pass parsing mechanism which translates said SQL statement to an array of function pointers.
Claim 2
Independent Claim
114 words
A method for compiling source code to p-code or machine-language instructions, wherein the source code contains high-level source code with embedded SQL statements, said method comprising the steps of: reading the source code one line at a time to generate a read line of source code; determining whether said read line of source code is high level source code or an SQL statement; and compiling said read line of source code to p-code or machine-language instructions, wherein if said read line of source code is an SQL statement, said compilation of said read line of source code occurs in a one-pass parsing mechanism which translates said SQL statement to an array of function pointers.
Claim 3
Independent Claim
103 words
A method for compiling source code to p-code or machine-language instructions, wherein the source code contains high-level source code with embedded SQL statements, said method comprising the steps of: reading the source code one line at a time to generate a read line of source code; determining whether said read line of source code is high level source code or an SQL statement; and compiling said read line of source code to p-code or machine-language instructions, wherein if said read line of source code is an SQL statement, said compilation of said read line of source code occurs in a one-pass parsing mechanism.
Claim 4
Independent Claim
103 words
A method for compiling source code to p-code or machine-language instructions, wherein the source code contains high-level source code with embedded SQL statements, said method comprising the steps of: reading the source code one line at a time to generate a read line of source code; determining whether said read line of source code is high level source code or an SQL statement; and compiling said read line of source code to p-code or machine-language instructions, wherein if said read line of source code is an SQL statement, said compilation of said read line of source code occurs in a one-pass parsing mechanism.
Claim 5
Dependent Claim
43 words
A method for compiling source code to p-code or machine-language instructions according to claim 2, wherein if said read line of source code is a static SQL statement, said compilation of said read line of source code is optimized by an access plan.
Claim 6
Dependent Claim
43 words
A method for compiling source code to p-code or machine-language instructions according to claim 2, wherein if said read line of source code is an SQL statement, said compilation of said read line of source code processes and maintains the scope of variables.
Claim 7
Dependent Claim
28 words
A method for compiling source code to p-code or machine-language instructions according to claim 2, further comprising writing said p-code or machine-language instructions to an output executable file.
Claim 8
Dependent Claim
31 words
A method for compiling source code to p-code or machine-language instructions according to claim 2, wherein said one-pass parsing mechanism comprises translating said SQL statement to a plurality of API statements.
Claim 9
Dependent Claim
31 words
A method for compiling source code to p-code or machine-language instructions according to claim 2, wherein said one-pass parsing mechanism comprises translating said SQL statement to an array of function pointers.
Claim 10
Independent Claim
105 words
A system for compiling source code to p-code or machine-language instructions, wherein the source code contains high level source code with embedded SQL statements, comprising: reading means to read the source code one line at a time and generate a read line of source code; determining means to identify said read line of source code as a line of high level source code or an SQL statement; and compiling means to parse said read line of source code and generate p-code or machine-language instructions, wherein if said read line of source code is an SQL statement, said compiling means occurs in a one-pass parsing mechanism.
Claim 11
Independent Claim
105 words
A system for compiling source code to p-code or machine-language instructions, wherein the source code contains high level source code with embedded SQL statements, comprising: reading means to read the source code one line at a time and generate a read line of source code; determining means to identify said read line of source code as a line of high level source code or an SQL statement; and compiling means to parse said read line of source code and generate p-code or machine-language instructions, wherein if said read line of source code is an SQL statement, said compiling means occurs in a one-pass parsing mechanism.
Claim 12
Dependent Claim
44 words
A system for compiling source code to p-code or machine-language instructions according to claim 8, wherein if said read line of source code is a static SQL statement, said compiling means of said read line of source code is optimized by an access plan.
Claim 13
Dependent Claim
44 words
A system for compiling source code to p-code or machine-language instructions according to claim 8, wherein if said read line of source code is an SQL statement, said compiling means of said read line of source code processes and maintains the scope of variables.
Claim 14
Dependent Claim
31 words
A system for compiling source code to p-code or machine-language instructions according to claim 8, further comprising writing means to write said p-code or machine-language instructions to an output executable file.
Claim 15
Dependent Claim
35 words
A system for compiling source code to p-code or machine-language instructions according to claim 8, wherein said one-pass parsing mechanism of said compiling means comprises translating said SQL statement to a plurality of API statements.
Claim 16
Dependent Claim
35 words
A system for compiling source code to p-code or machine-language instructions according to claim 8, wherein said one-pass parsing mechanism of said compiling means comprises translating said SQL statement to an array of function pointers.
Claim 17
Dependent Claim
157 words
An article of manufacture comprising: a computer usable medium having computer readable program code means embodied therein for causing a compilation from source code to p-code or machine-language instructions, wherein the source code contains high level source code embedded with SQL statements, said computer readable program code means in said article of manufacture comprising: computer readable program code means for causing a computer to read the source code one line at a time and generate a read line of source code; computer readable program code means for causing a computer to determine whether said read line of source code is high-level source code or an SQL statement; and computer readable program code means for causing a computer to compile said read line of source code to p-code or machine-language instructions, wherein if said read line of source code is an SQL statement, said compilation of said read line of source code occurs in a one-pass parsing mechanism.
Claim 18
Dependent Claim
157 words
An article of manufacture comprising: a computer usable medium having computer readable program code means embodied therein for causing a compilation from source code to p-code or machine-language instructions, wherein the source code contains high level source code embedded with SQL statements, said computer readable program code means in said article of manufacture comprising: computer readable program code means for causing a computer to read the source code one line at a time and generate a read line of source code; computer readable program code means for causing a computer to determine whether said read line of source code is high-level source code or an SQL statement; and computer readable program code means for causing a computer to compile said read line of source code to p-code or machine-language instructions, wherein if said read line of source code is an SQL statement, said compilation of said read line of source code occurs in a one-pass parsing mechanism.
Claim 19
Dependent Claim
36 words
An article of manufacture according to claim 14 wherein if said read line of source code is a static SQL statement, said compilation of said read line of source code is optimized by an access plan.
Claim 20
Dependent Claim
36 words
An article of manufacture according to claim 14 wherein if said read line of source code is an SQL statement, said compilation of said read line of source code processes and maintains the scope of variables.
Claim 21
Dependent Claim
21 words
An article of manufacture according to claim 14, further comprising writing said p-code or machine-language instructions to an output executable file.
Claim 22
Dependent Claim
24 words
An article of manufacture according to claim 14, wherein said one-pass parsing mechanism comprises translating said SQL statement to a plurality of API statements.
Claim 23
Dependent Claim
24 words
An article of manufacture according to claim 14, wherein said one-pass parsing mechanism comprises translating said SQL statement to an array of function pointers.
Claim 24
Dependent Claim
120 words
A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform method steps for compiling source code to p-code or machine-language instructions, wherein the source code contains high-level source code with embedded SQL statements, said method steps comprising: reading the source code one line at a time to generate a read line of source code; determining whether said read line of source code is high-level source code or an SQL statement; and compiling said read line of source code to p-code or machine-language instructions, wherein if said read line of source code is an SQL statement, said compilation of said read line of source code occurs in a one-pass parsing mechanism.
Claim 25
Dependent Claim
120 words
A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform method steps for compiling source code to p-code or machine-language instructions, wherein the source code contains high-level source code with embedded SQL statements, said method steps comprising: reading the source code one line at a time to generate a read line of source code; determining whether said read line of source code is high-level source code or an SQL statement; and compiling said read line of source code to p-code or machine-language instructions, wherein if said read line of source code is an SQL statement, said compilation of said read line of source code occurs in a one-pass parsing mechanism.
Claim 26
Dependent Claim
36 words
A program storage device according to claim 20, wherein if said read line of source code is a static SQL statement, said compiling of said read line of source code is optimized by an access plan.
Claim 27
Dependent Claim
36 words
A program storage device according to claim 20 wherein if said read line of source code is an SQL statement, said compiling of said read line of source code processes and maintains the scope of variables.
Claim 28
Dependent Claim
21 words
A program storage device according to claim 20, further comprising writing said p-code or machine-language instructions to an output executable file.
Claim 29
Dependent Claim
24 words
A program storage device according to claim 20, wherein said one-pass parsing mechanism comprises translating said SQL statement to a plurality of API statements.
Claim 30
Dependent Claim
24 words
A program storage device according to claim 20, wherein said one-pass parsing mechanism comprises translating said SQL statement to an array of function pointers.
References Cited (Backward Citations)
US4719564A
Cited
US5210876A
Cited
US5230049A
Cited
US5551015A
Cited
US5371747A
Cited
US5504885A
Cited
US5742828A
Cited
US5694598A
Cited
US5850550A
Cited
US5875334A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-05-16 | 2003-11-15 | 2004-05-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-05-16 | 2007-11-15 | 2008-05-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-05-16 | 2011-11-15 | 2012-05-16 | $7700.00 | Window Closed / Lapsed |