Progress
SQL-92
Guide and Reference
Glossary
Add [ an ODBC Data Source ]Makes a data source available to ODBC through the Add operation of the ODBC Administrator utility. Adding a data source tells ODBC where a specific database resides and which ODBC driver to use to access it. Adding a data source also invokes a setup dialog box for the particular driver so you can provide other details the driver needs to connect to the database.
AliasA temporary name for a table or column specified in the FROM clause of an SQL query expression. Also called Correlation Name. Derived tables and search conditions that join a table with itself must specify an alias. Once a query specifies an alias, references to the table or column must use the alias and not the underlying table or column name.
AppletA special kind of Java program that a Java-enabled browser can download over the network and execute.
ASCII(American Standard Code for Information Interchange) seven-bit character set that provides 128 character combinations.
BytecodeMachine-independent code generated by a Java compiler and executed by a Java interpreter.
CardinalityNumber of rows in a result table.
Cartesian ProductAlso called Cross-Product. In a query expression, the result table generated when a FROM clause lists more than one table but specifies no join conditions. In such a case, the result table is formed by combining every row of every table with all other rows in all tables. Typically, Cartesian products are not useful and are slow to process.
ClientGenerally, in client server systems, the part of the system that sends requests to Servers and receives the results produced by acting on those requests.
CollationThe rules used to control how character strings in a character set compare with each other. Each character set specifies a collating sequence that defines relative values of each character for comparing, merging, and sorting character strings.
Column AliasAn alias specified for a column. See Alias.
ConstraintPart of an SQL table definition that restricts the values that can be stored in a table. When you insert, delete, or update column values, the constraint checks the new values against the conditions specified by the constraint. If the value violates the constraint, it generates an error. Along with Triggers, constraints enforce Referential Integrity by ensuring that a value stored in the foreign key of a table must either be null or be equal to some value in the matching unique or primary key of another table.
Correlation NameAnother term for Alias.
Cross ProductAnother term for Cartesian Product.
Data DictionaryAnother term for System Catalog.
Data SourceSee ODBC Data Source.
Derived TableA Virtual Table specified as a query expression in the FROM clause of another query expression.
Driver ManagerSee JDBC Driver Manager and ODBC Driver Manager.
Form of UseThe storage format for characters in a character set. Some character sets, such as ASCII, require one byte (Octet) for each character. Others, such as Unicode, use multiple bytes, and are called multi-octet character sets.
Java SnippetSee Snippet.
JDBC(Java Database Connectivity) A database-independent SQL interface that allows Java programs to access relational databases. JDBC is quite similar to ODBC.
JDBC DriverDatabase-specific software that receives calls from the JDBC Driver Manager, translates them into a form that a database server can process, and then returns data to the application.
JDBC Driver ManagerA Java class that implements methods to route calls from a JDBC application to the appropriate JDBC Driver for a particular JDBC URL.
JoinA relational operation that combines data from two tables.
Input ParameterIn a Stored Procedure specification, an argument that an application must pass when it calls the stored procedure. In an SQL statement, a Parameter Marker in the statement string that acts as a placeholder for a value that will be substituted when the statement executes.
InterfaceIn Java, a definition of a set of methods that one or more objects will implement. Interfaces declare only methods and constants, not variables.
MetadataData that describes the objects (tables, columns, views, and indexes) that are stored in the database. Metadata is “data about data.” It is stored in a collection of tables called System Tables.
OctetA group of eight bits. Synonymous with byte, and often used in descriptions of character set encoding format.
ODBC ApplicationAny program that calls ODBC functions and uses them to issue SQL statements.
ODBC Data SourceIn ODBC terminology, a specific combination of a database system, the operating system it uses, and any network software required to access it. Before applications can access a database through ODBC, you use the ODBC Administrator to add a data source-register information about the database and an ODBC driver that can connect to it-for that database. More than one data source name can refer to the same database, and deleting a data source does not delete the associated database.
ODBC DriverSoftware that processes ODBC function calls for a specific data source. The driver connects to the data source, translates the standard SQL statements into syntax the data source can process, and returns data to the application. Progress SQL-92 includes an ODBC Driver.
ODBC Driver ManagerA Microsoft-supplied program that routes calls from an application to the appropriate ODBC driver for a data source.
Output ParameterIn a stored procedure specification, an argument in which the stored procedure returns a value after it executes.
PackageA group of related Java classes and interfaces, like a class library in C++. The Java development environment includes many packages of classes that procedures can import. The Java run-time system automatically imports the java.lang package. Stored procedures must explicitly import other classes by specifying them in the IMPORT clause of a CREATE PROCEDURE statement.
Parameter MarkerA question mark (?) character in a procedure call or SQL statement string that acts as a placeholder for a parameter’s value. The actual value for the input or output parameter will be supplied at run time when the procedure executes. The CALL statement (or corresponding ODBC or JDBC escape clause) uses parameter markers to pass parameters to stored procedures, and the SQLIStatement, SQLPStatement, and SQLCursor objects use them within procedures.
Primary KeyA subset of the columns in a table, characterized by the constraint that no two records in a table can have the same primary key value, and that no columns of the primary key can have a null value. Primary keys are specified in a CREATE TABLE statement.
Procedure BodyIn a Stored Procedure, the Java code between the BEGIN and END keywords of a CREATE PROCEDURE statement.
Procedure Result SetIn a stored procedure, a set of data rows returned to the calling application. The number and data types of columns in the procedure result set are specified in the RESULT clause of the CREATE PROCEDURE statement. The procedure can transfer data from an SQL Result Set to the procedure result set or it can store data generated internally. A stored procedure can have only one procedure result set.
Procedure SpecificationIn a CREATE PROCEDURE statement, the clauses preceding the procedure body that specify the procedure name, any input and output parameters, any result set columns, and any Java packages to import.
Procedure VariableA Java variable declared within the body of a stored procedure, as compared to a procedure Input Parameter or Output Parameter, which are declared outside the procedure body and are visible to the application that calls the stored procedure.
Query ExpressionAn important element of the SQL languages. Query expressions specify a result table derived from some combination of rows from the tables or views identified in the FROM clause of the expression. Query expressions are the basis of the SELECT, UPDATE, DELETE, and INSERT statements, and can be used in some expressions and search conditions.
Referential IntegrityThe condition where the value stored in a database table’s foreign key must either be null or be equal to some value in another table’s matching unique or primary key. SQL provides two mechanisms to enforce referential integrity: constraints specified as part of CREATE TABLE statements prevent updates that violate referential integrity, and Triggers specified in CREATE TRIGGER statements execute a stored procedure to enforce referential integrity.
RepertoireThe set of characters allowed in a character set.
Result SetIn a Stored Procedure, either an SQL Result Set or a Procedure Result Set.
More generally, another term for Result Table.
Result TableA virtual table of values derived from columns and rows of one or more tables that meet conditions specified by an SQL query expression.
Row IdentifierAnother term for Tuple identifier.
Search ConditionThe SQL syntax element that specifies a condition that is true or false about a given row or group of rows. Query expressions and UPDATE statements can specify a search condition. The search condition restricts the number of rows in the result table for the query expression or UPDATE statement. Search conditions contain one or more predicates. Search conditions follow the WHERE or HAVING keywords in SQL statements.
SelectivityThe fraction of a table’s rows returned by a query.
ServerGenerally, in client server systems, the part of the system that receives requests from Clients and responds by sending back the results produced by acting on them.
SnippetIn a stored procedure, the sequence of Java statements between the BEGIN and END keywords in the CREATE PROCEDURE (or CREATE TRIGGER) statement. The Java statements become a method in a class that SQL creates and submits to the Java compiler.
SQL Diagnostics AreaA data structure that contains information about the execution status (success, error, or warning conditions) of the most recent SQL statement. The SQL-92 standard specified the diagnostics area as a standardized alternative to widely varying implementations of the SQLCA. Progress SQL-92 supports both the SQLCA and the SQL diagnostics area. The SQL GET DIAGNOSTICS statement returns information about the diagnostics area to an application, including the value of the SQLSTATE status parameter.
SQLCASQL Communications area. A data structure that contains information about the execution status (success, error, or warning conditions) of the most recent SQL statement. The SQLCA includes an SQLCODE field. The SQLCA provides the same information as the SQL diagnostics area, but is not compliant with the SQL-92 standard. Progress SQL-92 supports both the SQLCA and the SQL diagnostics area.
SQLCODEAn integer status parameter whose value indicates the condition status returned by the most recent SQL statement. An SQLCODE value of zero means success, a positive value means warning, and a negative value means an error status. SQLCODE is superseded by SQLSTATE in the SQL-92 standard. Applications declare either SQLSTATE or SQLCODE, or both. SQL returns the status to SQLSTATE or SQLCODE after execution of each SQL statement.
SQL Result SetIn a stored procedure, the set of data rows generated by an SQL statement (SELECT and, in some cases, CALL).
SQLSTATEA five-character status parameter whose value indicates the condition status returned by the most recent SQL statement. SQLSTATE is specified by the SQL-92 standard as a replacement for the SQLCODE status parameter (which was part of SQL-89). SQLSTATE defines many more specific error conditions than SQLCODE, which allows applications to implement more portable error handling. Applications declare either SQLSTATE or SQLCODE, or both. SQL returns the status to SQLSTATE or SQLCODE after execution of each SQL statement.
Stored ProcedureA snippet of Java source code embedded in an SQL CREATE PROCEDURE statement. The source code can use all standard Java features as well as use Progress SQL-92-supplied Java classes for processing any number of SQL statements.
System CatalogTables created by SQL to store descriptions of objects (tables, columns, views, and indexes) that are stored in the database.
System TableAnother term for System Catalog.
TidAnother term for Tuple Identifier.
TransactionA group of operations whose changes can be made permanent or undone only as a unit.
TriggerA special type of Stored Procedure that helps ensure referential integrity for a database. Like stored procedures, triggers also contain Java source code (embedded in a CREATE TRIGGER statement) and use Progress SQL-92 Java classes. However, triggers are automatically invoked (“fired”) by certain SQL operations (an insert, update, or delete operation) on the trigger’s target table.
Trigger Action TimeThe BEFORE or AFTER keywords in a CREATE TRIGGER statement. The trigger action time specifies whether the actions implemented by the Trigger execute before or after the triggering INSERT, UPDATE, or DELETE statement.
Trigger EventThe statement that causes a trigger to execute. Trigger events can be SQL INSERT, UPDATE, or DELETE statements that affect the table for which a trigger is defined.
Triggered ActionThe Java code within the BEGIN END clause of a CREATE TRIGGER statement. The code implements actions to be completed when a triggering statement specifies the target table.
Tuple IdentifierA unique identifier for a tuple (row) in a table. The SQL scalar function ROWID and related functions return tuple identifiers to applications.
UnicodeA superset of the ASCII character set that uses multiple bytes for each character rather than ASCII’s seven-bit representation. Able to handle 65,536 character combinations instead of ASCII’s 128, Unicode includes alphabets for many of the world’s languages. The first 128 codes of Unicode are identical to ASCII, with a second-byte value of zero.
ViewA Virtual Table that re-creates the result table specified by a SELECT statement. No data is stored in a view, but other queries can refer to it as if it were a table containing data corresponding to the result table it specifies.
Virtual TableA table of values that is not physically stored in a database, but instead derived from columns and rows of other tables. SQL generates virtual tables in its processing of query expressions: the FROM, WHERE, GROUP BY, and HAVING clauses each generate a virtual table based on their input.
Virtual MachineThe Java specification for a hardware-independent and portable language environment. Java language compilers generate code that can execute on a virtual machine. Implementations of the Java virtual machine for specific hardware and software platforms allow the same compiled code to execute without modification.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |