Filter
Top Products
Database space
An area that stores base tables and indexes. Database space is created by physical structure definition in
SymfoWARE/RDB.
Deadlock
A stopped status that occurs when several transactions share use of a database. A deadlock is to a loop that occurs
when several transactions wait for the same resource. Each transaction waits for another transaction to release the
resource, and all transactions in the loop end up in stopped status.
Related terms:
Transaction, exclusive control
DEFAULT clause
An element of the definition of a column in a table. If the following condition applies, the value defined in the DEFAULT
clause is inserted. The data to be inserted in a column is not specified when a row is inserted in a table using the
INSERT statement. If a DEFAULT clause is not defined for a column, a NULL value is inserted.
DELETE statement
The DELETE statement is data manipulation SQL statement used to delete rows from tables.
DSO
Expresses the storage structure for a table (base table). DSOs include table DSOs and index DSOs.
Related terms:
Storage structure, DSI
Dynamic SQL
Dynamic SQL is a function for generating and executing SQL statements when executing an application program. In
general, this function is used by general-purpose package programs.
Embedded exception declaration
An embedded exception declaration specifies the processing to be performed if an exception condition is issued when
and SQL statement is executed in an application program. The WHENEVER statement is used to specify an
embedded exception declaration.
Embedded SQL
SQL statements can be used as embedded SQL statements. Use embedded SQL statements to manipulate data in
application programs written in high-level languages such as C language or COBOL. For example, when COBOL is
used, specify an SQL statement embedded between EXEC SQL and END-EXEC.
204