NextPrevUpTopContentsIndex Specifying SQL directly

Sometimes it is necessary to execute vendor-specific SQL statements and queries. For these occasions Common SQL provides the functions query and execute-command . They can also be used when the exact SQL string is known in advance and thus the square bracket syntax is not needed.

The function query runs a SQL query on a database and returns a list of values like select (see Querying). It also returns a list of the field names selected.

execute-command is the basic function which executes any SQL statement other than a query. A stored procedure can be run using execute-command - see the LispWorks Reference Manual for details.

LispWorks User Guide - 11 Mar 2008