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
© 2001-2020 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.