Esql
A generic name of the compiler function for embedded SQL C programs or embedded SQL COBOL programs.
Embedded SQL C programs and embedded SQL COBOL programs are called as shown below:
Embedded SQL C program:
Esql-c
Embedded SQL COBOL program:
Esql-COBOL
Excel
Developed by Microsoft Corporation, Excel is spreadsheet software that runs on a workstation.
Exception condition
When an SQL statement is executed in an application program, data to be processed may not be able to be found or
an error may occur. Such a condition is known as an exception condition or exception. if an exception condition occurs
while an application program is running, the status code corresponding to be exception condition is set in SQLSTATE.
Exclusive control
Control used when multiple users use a database. While one user is updating the database, other users cannot
reference the data being updated or cause data conflicts by updating the data being updated. This function is
generally called locking.
External routine
A user-created program (written in a language such as C) registered to a server as a dynamic link library called from
an SQL statement. External routines have an advantage because they use C and other languages to enable complex
processing such as formatting of character string data to be easily accomplished. Such processing with SQL functions
has limitations.
With SymfoWARE/RDB, C can be used for creating external routines.
Function routine
A function that defines a user-created C program as a function in an SQL statement and processes it.
Users can create functions that they want and that are not provided by SymfoWARE/RDB, and they can use them in
SQL statements in the same way as for numeric, data string, and date-and-time functions.
Hash function
The function used to specify the collection of pages that store data from the value of the group of columns that form
the data key. Unique to RANDOM structures.
Related term:
RANDOM structure
205