Download Informix Guide to SQL: Reference

Transcript
Tech Review Draft Tech Review Draft Tech Review Draft Tech Review Draft Tech Review Draft Tech Review Draft Tech Review Draft Tech
deadlock
A situation in which two or more threads cannot proceed because each is
waiting for data locked by the other (or another) thread. Informix Dynamic
Server monitors and prevents potential deadlock situations by sending an
error message to the application whose request for a lock may result in a
deadlock.
debug file
A file that receives output used for debugging purposes.
decision-support
application
An application that provides information which is used for strategic
planning, decision-making, and reporting. It typically executes in a batch
environment in a sequential scan fashion and returns a large fraction of the
rows scanned. Decision-support queries typically scan the entire database.
See online transaction processing application.
decision-support
query
A query that is generated by a decision-support application. It often requires
operations such as multiple joins, temporary tables, and extensive calculations, and can benefit significantly from PDQ. Also see OLTP query.
declaration
statement
A programming language statement that describes or defines objects, for
example, defining a program variable. Compare to procedural statement.
default
How a program acts or the values that are assumed if the user does not
explicitly specify an action.
default value
A value inserted into a column or variable when an explicit value is
not specified. Default values can be assigned to columns using the
ALTER TABLE and CREATE TABLE statements and to variables in stored
procedures.
delete
To remove any row or combination of rows with the DELETE statement.
delimited
identifier
An identifier surrounded by double quotes. The purpose of a delimited identifier is to allow usage of identifiers that are otherwise identical to SQL
reserved keywords or that contain non-alphabetical characters. See also
identifier.
delimiter
A boundary on an input field or the terminator for a column or row. Some
files and prepared objects require semicolon (;), comma (,), space, or tab
delimiters between statements.
deluxe mode
Dynamic Server with AD and XP Options method of loading or unloading
data that uses regular inserts.
12
Informix Guide to SQL: Reference