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