set options of a PreparedStatement module - Maple Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Connectivity : Database Package : PreparedStatement : Database/PreparedStatement/SetOptions

PreparedStatement:-SetOptions - set options of a PreparedStatement module

Calling Sequence

preparedstat:-SetOptions( opts )

Parameters

preparedstat

-

PreparedStatement module

opts

-

equation(s) of the form option=integer where option is one of timeout, maxrows, or maxfieldsize

Description

• 

SetOptions sets various options that affect the behavior of preparedstat.

• 

All the options that can be set with SetOptions can also be set when preparedstat is created by a call to CreateStatement.

• 

An option's current value can be obtained by calling GetOptions.

• 

SetOptions does not return anything.

• 

The following are the options that can be passed to SetOptions.

  

timeout = integer

  

the number of seconds preparedstat waits for a query to execute.  If the limit is exceeded, an error is raised.

  

maxrows = integer

  

the maximum number of rows a query returns. If there are more than maxrows rows in the database that match the query, the extra rows are dropped.

  

maxfieldsize = integer

  

the maximum number of bytes a field of type BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, or LONGVARCHAR will use. If a field needs more than this, it is truncated.

• 

Calling SetOptions with no arguments raises an error.

Examples

driver:=Database[LoadDriver]:

conn:=driver:-OpenConnectionurl,name,pass:pstat:=conn:-CreateStatement:pstat:-GetOptions

timeout=0,maxrows=0,maxfieldsize=8192

(1)

pstat:-SetOptions'timeout'=10;pstat:-GetOptions

timeout=10,maxrows=0,maxfieldsize=8192

(2)

pstat:-SetOptions'maxrows'=20;pstat:-GetOptions'timeout','maxrows'

timeout=10,maxrows=20

(3)

pstat:-SetOptions'maxfieldsize'=1000;pstat:-GetOptions'timeout','maxrows','maxfieldsize'

timeout=10,maxrows=20,maxfieldsize=1000

(4)

See Also

Database, Database[Connection], Database[Connection][CreateStatement], Database[PreparedStatement], Database[PreparedStatement][GetOptions], Database[Statement], Database[usage]


Download Help Document

Was this information helpful?



Please add your Comment (Optional)
E-mail Address (Optional)
What is ? This question helps us to combat spam