No preprocessor and a source level debugger for embedded SQL in a 3GL

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.

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.

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.

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.