Functional Data Manipulation Language (FDML)
Prev
Next
Functional Data Manipulation Language (FDML)
Table of Contents
*CACHE-TABLE-QUERIES-DEFAULT*
- Specifies the default behaviour for caching of attribute types.
CACHE-TABLE-QUERIES
- Controls the caching of attribute type information for a database table.
INSERT-RECORDS
- Insert tuples of data into a database table.
UPDATE-RECORDS
- Updates the values of existing records.
DELETE-RECORDS
- Delete records from a database table.
EXECUTE-COMMAND
- Execute an SQL command which returns no values.
QUERY
- Execute an SQL query and return the tuples as a list.
PRINT-QUERY
- Prints a tabular report of query results.
SELECT
- Executes a query given the supplied constraints.
DO-QUERY
- Iterate over all the tuples of a query.
FOR-EACH-ROW
-
LOOP
- Iterate over all the tuples of a query via a loop clause.
MAP-QUERY
- Map a function over all the tuples from a query
PREPARE-SQL
- Create a prepared statement.
RUN-PREPARED-SQL
- Execute a prepared statement.
FREE-PREPARED-SQL
- Delete a prepared statement object.
BIND-PARAMETER
- Bind a parameter in a prepared statement.