Patent US5850550A successfully refreshed from Google Patents.
US5850550A
Expired / Lapsed
US
⏱️ 0.0 years remaining
No preprocessor and a source level debugger for embedded SQL in a 3GL
Assignee: International Business Machines Corp
•
Filing: 1995-08-31
•
Granted: 1998-12-15
•
Expires: 2015-08-31
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 15:36
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
194 words
A method for translating 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: (1) reading the source code one line at a time to generate a read line of source code; (2) determining whether said read line of source code is a line of high level source code or an SQL statement; (3) translating said read line of source code to p-code or machine-language instructions, wherein said translation of said read line of source code occurs in a one-pass parsing mechanism which translates said line of high level source code if it is determined in step (2) that said read line of source code is said line of high level source code, and which translates said SQL statement if it is determined in step (2) that said read line of source code is said SQL statement, wherein said SQL statement is translated to an array of function pointers; and (4) annotating each of said p-code or machine-language instructions wherein said annotation identifies said read line of source code corresponding to said each of said p-code or machine-language instructions.
Claim 2
Independent Claim
194 words
A method for translating 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: (1) reading the source code one line at a time to generate a read line of source code; (2) determining whether said read line of source code is a line of high level source code or an SQL statement; (3) translating said read line of source code to p-code or machine-language instructions, wherein said translation of said read line of source code occurs in a one-pass parsing mechanism which translates said line of high level source code if it is determined in step (2) that said read line of source code is said line of high level source code, and which translates said SQL statement if it is determined in step (2) that said read line of source code is said SQL statement, wherein said SQL statement is translated to an array of function pointers; and (4) annotating each of said p-code or machine-language instructions wherein said annotation identifies said read line of source code corresponding to said each of said p-code or machine-language instructions.
Claim 3
Independent Claim
182 words
A method for translating 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: (1) reading the source code one line at a time to generate a read line of source code; (2) determining whether said read line of source code is a line of high level source code or an SQL statement; (3) translating said read line of source code to p-code or machine-language instructions, wherein said translation of said read line of source code occurs in a one-pass parsing mechanism which translates said line of high level source code if it is determined in step (2) that said read line of source code is said line of high level source code, and which translates said SQL statement if it is determined in step (2) that said read line of source code is said SQL statement; and (4) annotating each of said p-code or machine-language instructions wherein said annotation identifies said read line of source code corresponding to said each of said p-code or machine-language instructions.
Claim 4
Independent Claim
182 words
A method for translating 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: (1) reading the source code one line at a time to generate a read line of source code; (2) determining whether said read line of source code is a line of high level source code or an SQL statement; (3) translating said read line of source code to p-code or machine-language instructions, wherein said translation of said read line of source code occurs in a one-pass parsing mechanism which translates said line of high level source code if it is determined in step (2) that said read line of source code is said line of high level source code, and which translates said SQL statement if it is determined in step (2) that said read line of source code is said SQL statement; and (4) annotating each of said p-code or machine-language instructions wherein said annotation identifies said read line of source code corresponding to said each of said p-code or machine-language instructions.
Claim 5
Dependent Claim
43 words
A method for translating 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 translation of said read line of source code is optimized by an access plan.
Claim 6
Dependent Claim
43 words
A method for translating 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 translation of said read line of source code processes and maintains the scope of variables.
Claim 7
Dependent Claim
28 words
A method for translating 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 translating 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 translating 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
160 words
A system for translating 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; translating means to parse said read line of source code and generate p-code or machine-language instructions, wherein said translating means occurs in a one-pass parsing mechanism which translates said line of high level source code if it determined that said read line of source code is said line of high level source code, and which translates said SQL statement if it is determined that said read line of source is said SQL statement; and annotating means to annotate said p-code or machine-language instructions with a reference to a corresponding line of source code.
Claim 11
Independent Claim
160 words
A system for translating 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; translating means to parse said read line of source code and generate p-code or machine-language instructions, wherein said translating means occurs in a one-pass parsing mechanism which translates said line of high level source code if it determined that said read line of source code is said line of high level source code, and which translates said SQL statement if it is determined that said read line of source is said SQL statement; and annotating means to annotate said p-code or machine-language instructions with a reference to a corresponding line of source code.
Claim 12
Dependent Claim
44 words
A system for translating 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 translating means of said read line of source code is optimized by an access plan.
Claim 13
Dependent Claim
44 words
A system for translating 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 translating means of said read line of source code processes and maintains the scope of variables.
Claim 14
Dependent Claim
31 words
A system for translating 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 translating source code to p-code or machine-language instructions according to claim 8, wherein said one-pass parsing mechanism of said translating means comprises translating said SQL statement to a plurality of API statements.
Claim 16
Dependent Claim
35 words
A system for translating source code to p-code or machine-language instructions according to claim 8, wherein said one-pass parsing mechanism of said translating means comprises translating said SQL statement to an array of function pointers.
Claim 17
Dependent Claim
236 words
An article of manufacture comprising: a computer usable medium having computer readable program code means embodied therein for causing a translation 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 a line of high-level source code or an SQL statement; computer readable program code means for causing a computer to translate said read line of source code to p-code or machine-language instructions, wherein said translation of said read line of source code occurs in a one-pass parsing mechanism which translates said line of high level source code if it is determined that said read line of source code is said line of high level source code, and which translates said SQL statement if it is determined that said read line of source code is said SQL statement; and computer readable program code means for causing the computer to annotate each of said p-code or machine-language instructions wherein said annotation identifies said read line of source code corresponding to said each of said p-code or machine-language instructions.
Claim 18
Dependent Claim
236 words
An article of manufacture comprising: a computer usable medium having computer readable program code means embodied therein for causing a translation 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 a line of high-level source code or an SQL statement; computer readable program code means for causing a computer to translate said read line of source code to p-code or machine-language instructions, wherein said translation of said read line of source code occurs in a one-pass parsing mechanism which translates said line of high level source code if it is determined that said read line of source code is said line of high level source code, and which translates said SQL statement if it is determined that said read line of source code is said SQL statement; and computer readable program code means for causing the computer to annotate each of said p-code or machine-language instructions wherein said annotation identifies said read line of source code corresponding to said each of said p-code or machine-language instructions.
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 translation 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 translation 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
197 words
A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform method steps for translating 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: (1) reading the source code one line at a time to generate a read line of source code; (2) determining whether said read line of source code is a line of high-level source code or an SQL statement; translating said read line of source code to p-code or machine-language instructions, wherein said translation of said read line of source code occurs in a one-pass parsing mechanism which translates said line of high level source code if it is determined in step (2) that said read line of source code is said line of high level source code, and which translates said SQL statement if it is determined in step (2) that said read line of source code is said SQL statement; and annotating each of said p-code or machine-language instructions wherein said annotation identifies said read line of source code corresponding to said each of said p-code or machine-language instructions.
Claim 25
Dependent Claim
197 words
A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform method steps for translating 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: (1) reading the source code one line at a time to generate a read line of source code; (2) determining whether said read line of source code is a line of high-level source code or an SQL statement; translating said read line of source code to p-code or machine-language instructions, wherein said translation of said read line of source code occurs in a one-pass parsing mechanism which translates said line of high level source code if it is determined in step (2) that said read line of source code is said line of high level source code, and which translates said SQL statement if it is determined in step (2) that said read line of source code is said SQL statement; and annotating each of said p-code or machine-language instructions wherein said annotation identifies said read line of source code corresponding to said each of said p-code or machine-language instructions.
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 translating 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 translating 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)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-12-14 | 2002-06-15 | 2002-12-15 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-12-14 | 2006-06-15 | 2006-12-15 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-12-14 | 2010-06-15 | 2010-12-15 | $7700.00 | Window Closed / Lapsed |