- Industry: Computer
- Number of terms: 98482
- Number of blossaries: 0
- Company Profile:
Sometimes referred to as “Big Blue” IBM is a multinational corporation headquartered in Armonk, New York. It manufactures computer hardware and software and provides information technology and services.
An SQL function that optionally accepts arguments and that returns a single row of values. A row function can be implemented in SQL and used as a transform function to map attributes of a structured type to built-in data type values in a row. See also function, routine.
Industry:Software
An SQL function that optionally accepts arguments and that returns a single scalar value each time that it is invoked. A scalar function can be referenced in an SQL statement wherever an expression is valid. See also function, routine.
Industry:Software
An SQL operation that involves the INTERSECT set operator, which combines two result tables. The result of an intersection operation consists of all of the rows that are in both result tables.
Industry:Software
An SQL or XQuery statement for which an explain operation was performed.
Industry:Software
An SQL or XQuery statement for which the explain operation can be performed. SELECT, UPDATE, INSERT, DELETE, and VALUES are explainable SQL statements.
Industry:Software
An SQL procedure that is processed by converting the procedural statements to a native representation that is stored in the database directory, as is done with other SQL statements. When a native SQL procedure is called, the native representation is loaded from the directory, and DB2 executes the procedure. See also external procedure, external SQL procedure.
Industry:Software
An SQL procedure that is processed using a generated C programme that is a representation of the procedure. When an external SQL procedure is called, the C programme representation of the procedure is executed in a stored procedures address space. See also external procedure, native SQL procedure.
Industry:Software
An SQL statement or XQuery expression that can be embedded in an application program, dynamically prepared and executed, or issued interactively.
Industry:Software
An SQL statement that is coded within an application program. See also Call Level Interface.
Industry:Software
An SQL statement that is prepared and executed at run time. In dynamic SQL, the SQL statement is contained as a character string in a host variable and is not precompiled. See also deferred embedded SQL, static SQL, incremental bind statement.
Industry:Software
