CreateStatement opens a Statement module.  This Statement module can be used to send arbitrary SQL statements to the database.

CreateStatement accepts as optional arguments the same options that can be set with Statement:-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{stat1}≔\mathrm{conn}:-\mathrm{CreateStatement}\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{stat2}≔\mathrm{conn}:-\mathrm{CreateStatement}\left('\mathrm{timeout}'=10\right)\:$$\mathrm{stat3}≔\mathrm{conn}:-\mathrm{CreateStatement}\left('\mathrm{timeout}'=5\,'\mathrm{maxrows}'=100\right)\:$