run-prepared-sql

$Revision: 1.1.2.3 $

Function

Package: DBI

Arguments: (&key db hstmt row-count width)

Execute the sql statement that was last prepared via prepare-sql. The prepared sql statement is associated with the statement handle.

If statement handle hstmt is non-nil then it is used for the conversation with its associated database. Otherwise if db is non-nil then it is the database on which the sql statement will be run. If db is also nil then the database used is the one that is the value of *default-database*.

width is the size for character buffers used in retrieving character-valued fields. If not given, then the width for the database, db-width, is used.

If the sql statement is parameterized then values for all of the parameters must be bound before the statement is executed.

The returned values are the same as for the sql function and are documented in sql's description.

This symbol is associated with the Allegro CL ODBC (AODBC) interface, version 2. Version 2 is new in Allegro CL 5.0.1. It is incompatible with the earlier version 1. Not all customers will have Allegro ODBC version 2. Contact your Franz Inc. sales representative for more information.

Allegro ODBC version 2 is described in aodbc_v2.htm.

The general documentation description is in introduction.htm. The index in index.htm.