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.