CreatePreparedStatement returns a PreparedStatement module.  This PreparedStatement module can be used to send a prepared SQL statement to the database. For information on prepared statements see the PreparedStatement page.

CreatePreparedStatement accepts as optional arguments the same options that can be set with preparedstatement:-SetOptions.

timeout = integer

The number of seconds the client waits for a response from the database.

maxrows = integer

The maximum number of rows a query returns.

maxfieldsize = integer

The maximum number of bytes that a column uses to store character or binary data.  This only applies to columns of type BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR. If the limit is exceeded, then the extra data is ignored.

$\mathrm{driver}≔\mathrm{Database}\left[\mathrm{LoadDriver}\right]\left(\right)\:$

$\mathrm{conn}≔\mathrm{driver}:-\mathrm{OpenConnection}\left(\mathrm{url}\,\mathrm{name}\,\mathrm{pass}\right)\:$

$\mathrm{pstat1}≔\mathrm{conn}:-\mathrm{CreatePreparedStatement}\left(\right)$

$\mathrm{stat1}≔\mathbf{module}\left(\right)\mathbf{option}\mathrm{unload}\=\mathrm{Close}\;\mathbf{local}\mathrm{handle}\;\mathbf{export}\mathrm{Execute}\,\mathrm{NextResult}\,\mathrm{Close}\,\mathrm{SetOptions}\,\mathrm{GetOptions}\;\mathbf{end\; module}$

$\mathrm{pstat2}≔\mathrm{conn}:-\mathrm{CreatePreparedStatement}\left('\mathrm{timeout}'=10\right)\:$$\mathrm{pstat3}≔\mathrm{conn}:-\mathrm{CreatePreparedStatement}\left('\mathrm{timeout}'=5\,'\mathrm{maxrows}'=100\right)\:$