Abstract: An application creation tool includes: a first component and a second component, where a name of the first and second components in accordance with a naming scheme is based on a plurality of attributes for an application which the first and the second components create. Each component pertains to one variation of the combination of attributes, such as the programming language, the application type, the server type, and the service type for the application to be created. Each component is named according to the naming scheme based on these attributes. When a service request for the tool is issued, the tool uses the four attributes to determine the name of the appropriate component. In this manner, the complexity of the application creation tool is reduced. This makes the tool easily maintainable and easier to upgrade.

Abstract: A method, apparatus, and article of manufacture for providing a programming development environment that supports the development of portable server routines. More specifically, the present invention discloses a method for storing and retrieving server routines within the database independent of any file I/O system. Also, the present invention discloses a debugging environment that allows debugging of server routines in a multi-tier environment, wherein the source code being debugged runs on the development machine.

Abstract: A method, apparatus, and article of manufacture and memory for providing a programming development environment that supports the development of Internet and Intranet applications. More specially, the present invention discloses an efficient, versatile dynamic debugger that allows platform-independent debugging of applications written in a wide variety of languages.

Abstract: A method and apparatus for generating a Common Gateway Interface (CGI) adaptor customized for a stored procedure. In accordance with the present invention, stored procedure application developers can provides their stored procedure to a builder, which creates a CGI adaptor customized for the stored procedure. To generate the CGI adaptor, the builder parses the stored procedure to identify the arguments of the stored procedure. Then, using the stored procedure arguments, the builder generates logic to extract variables from an input data stream, wherein the variables correspond to the arguments of the stored procedure. The builder also generates logic to invoke the stored procedure using the variables extracted from the input data stream. The generated logic comprises the customized CGI adaptor.

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.

Abstract: A method and apparatus for generating a Common Gateway Interface (CGI) adaptor customized for a stored procedure. In accordance with the present invention, stored procedure application developers can provides their stored procedure to a builder, which creates a CGI adaptor customized for the stored procedure. To generate the CGI adaptor, the builder parses the stored procedure to identify the arguments of the stored procedure. Then, using the stored procedure arguments, the builder generates logic to extract variables from an input data stream, wherein the variables correspond to the arguments of the stored procedure. The builder also generates logic to invoke the stored procedure using the variables extracted from the input data stream. The generated logic comprises the customized CGI adaptor.

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.