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.