DBPanacea

Clone

A SQLEditor command used to create a new SQL statement identical to an existing statement.

command ID

1. A numeric identifier for a SQL statement. You assign a command ID to a statement in SQLEditor. To identify the statement you want to use in a template, use the <CMD> tag with the command ID.
2. An internal identifier that appears on the server log for client or server requests received by DBServer. This command ID is not related to the SQLEditor command ID.

failover

The process by which a Web server configuration diverts incoming traffic from one computer to one or more networked computers for the purpose of balancing request loads and avoiding excessive strain on server resources.

HTML

Hypertext Markup Language, a markup language used for authoring Web documents.

JDBC

Java Database Connectivity driver that supports database connectivity for Java-based programs.

ODBC

Open Database Connectivity driver that supports database connectivity for Microsoft Access, Microsoft SQL Server, and other programs.

servlet

A servlet is a small Java program that runs on a server (as opposed to a Java applet that the server downloads to run on a Web client computer). With a servlet manager such as JRun or Jserv, a Web server such as Microsoft Internet Information Server can run a servlet. In DBPanacea, the servlet acts as an interface between the Web server and FormProcessor.

statement

In DBPanacea, an instruction written in SQL that retrieves data from or posts data to a database. Also known as a query. Statements typically include the following SQL commands: SELECT, UPDATE, MODIFY, or DELETE.

SQL

Structured query language, a language used to retrieve, update, and manage data in a relational database.

SQL Wizard

A self-guided user interface for creating a new SQL statement. You can also create SQL statements "from scratch" or by creating a clone of an existing statement.

template

A DBPanacea file that contains generic HTML syntax, references to SQL statements, and custom formatting for presentation of database information in Web pages. DBPanacea names template files with the .pan extension.