Initializing help system before first use

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.
SQLfiltarr
Enable/disable array filtering.
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
Covered Topics
Parent Topic mmodbc

© 2001-2025 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.