$root.$sessions.ODBC

Parent: $root.$sessions

Properties

Object specific
$bytesreceived The number of bytes received through the session object since logon. Assigning to this property resets the value to zero.
$bytessent The number of bytes sent through the session object since logon. Assigning to this property resets the value to zero.
$codepage The code page used to interpret non-Unicode character data, a kUni… constant (see codepage constants)
$commitdelay The delay (in milliseconds) between each commit retry
$commitretries The number of times a commit operation will retry before conceding
$cursorsensitivity Whether cursors are sensitive to changes made by other cursors within the current transaction
$datesecdp The number of decimal places used for SQL Server date columns
$dbmsname Name of the session database
$dbmsversion Version of the session database
$debugfile If assigned, the DAM writes debug information to the specified file
$debuglevel Specifies the level of debug information required
$debugsize The maximum size of debug file generated before truncation occurs. Assigning zero disables truncation.
$defaultdatabase The default database to connect to at logon
$defaultschema The default schema associated with the current user. SQL Server 2005 only
$drivername Name of the session driver
$driverodbcversion ODBC version of the session driver
$driverversion Version of the session driver
$encoding The Unicode encoding used by the database (see encoding constants) kSessionEncodingAnsi kSessionEncodingUtf16 kSessionEncodingUtf32 kSessionEncodingUtf8
$fetch64bitints If kTrue, 64-bit integers are fetched into 64-bit Integer fields. If kFalse, they are fetched as 32-bit Integers and truncated accordingly
$infoaserror If kTrue, informational & warning messages are treated as errors. If kFalse, the DAM tries to ignore and carry on
$isolationlevel The current transaction isolation level in use by the session
$isolationoptions A kODBCIsolation... bitmask representing the isolation levels supported by the driver (See ODBC isolation level constants)
$logontimeout Timeout in seconds for logon
$mode A kODBCMode... value used for non-standard ODBC connections (See ODBC mode constants)
$multipleresultsets kTrue if the data source supports multiple result sets
$multipletransactions kTrue if the driver supports more than one active transaction at the same time
$nationaltowchar If true, Omnis National fields are mapped to wide character types and Omnis Character fields are mapped to 8-bit types
$nativewarncode Information or warning code generated by the last operation
$nativewarntext Information or warning message generated by the last operation
$programname The name to be registered at the server for this session
$querytimeout Timeout in seconds for a query
$quotedidentifier If kTrue, table instances and session methods will generate quoted column & table name identifiers
$rpcsupport If true, the connection supports procedures (RPCs)
$timezone The local timezone offset relative to GMT
$trustedconnection Enable/Disable logon using a server trusted connection
$txncapability The command types supported by SQL statements inside transactions
$unicode If kTrue, Unicode data types/mappings are used. If kFalse, DAM reverts to ANSI behavior
$usefiledsn The hostname specified at logon will be a file DSN
$uselogonprompt Prompt for missing logon information
$useprogramname Register $programname at logon
$usequalifiers Treat table names as 'owner.table'
$usetimezone If kTrue, $timezone will be applied to values inserted and fetched from TIME & TIMESTAMP columns
Standard $allowstransactions $apiversion $autobegintran $blobsize $charmap $commitmode $damname $defaultdate $emptydateisnull $errorcode $errortext$hostname $ident $lobchunksize $lobthreshold $maptable $name $nativeerrorcode $nativeerrorpending $nativeerrortext $password $rollbackmode$sessionobject $sessionobjref $sqldecimalseparator $sqlstripspaces $sqlthousandseparator $state $transactionmode $username $version

Methods

Object specific
$configdsn Adds, modifies or removes the specified ODBC DSN
$getdatasources Retrieves a list of ODBC DSNs of the specified type
$getdrivers Retrieves a list of installed ODBC drivers
$getinfo Retrieves information about the specified ODBC DSN or Driver
$getoption Retrieves the specified ODBC configuration attribute
$newstatement $newstatement([cStatementname]) Creates and returns a new dynamic instance of a statement object for the session; typically used to return a new statement object to an object variable with no subtype specified
ODBC statement object
$newstatementref $newstatementref([cStatementname]) Creates and returns a new dynamic instance of a statement object for the session, to be used with an Object reference variable; typically used to return a new statement to an object reference variable
ODBC statement object
$setinfo Adds or modifies information for the specified ODBC DSN or Driver
$setoption Sets the specified ODBC configuration option
Standard $begin $clear $coltext $commit $createnames $insertnames $logoff $logon $makeschema $nextnativeerror $rollback $rpcdefine $selectnames $updatenames$wherenames