Control parameters
The following parameters are defined by mmodbc:
| SQLautocommit |
Enable/disable auto commit mode.
|
| SQLautondx |
Enable automatic indexation of arrays.
|
| SQLbufsize |
Data buffer size.
|
| SQLcolsize |
Maximum string length.
|
| SQLconnection |
Identification number of the active ODBC connection.
|
| SQLdebug |
Enable/disable debug mode.
|
| SQLdm |
Driver manager currently used.
|
| SQLextn |
Enable/Disable extended syntax.
|
| SQLfirstndx |
Initial index value for an automatic indexation.
|
| SQLndxcol |
Indicate whether to use first columns as indices.
|
| SQLrowcnt |
Number of lines affected by the last SQL command.
|
| SQLrowxfr |
Number of lines transferred during the last SQL command.
|
| SQLsuccess |
Indicate whether the last SQL command succeeded.
|
| SQLtruncsize |
Length of the largest string that has been truncated.
|
| SQLverbose |
Enable/disable message printing by the ODBC driver.
|
All parameters can be accessed with the Mosel function getparam, and those that are not marked read-only in the list below may be set using the procedure setparam.
Example:
setparam("SQLverbose", true) ! Enable message printing by the ODBC driver
csize:=getparam("SQLcolsize") ! Get the maximum string length
setparam("SQLconnection", 3) ! Select the connection number 3