$root.$sessions.OMNISSQL

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
$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.
$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
$quotedidentifier If kTrue, table instances and session methods will generate quoted column & table name identifiers
$unicode If kTrue, Unicode data types/mappings are used. If kFalse, DAM reverts to ANSI behavior
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
$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
OMNISSQL 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
OMNISSQL statement object
Standard $begin $clear $coltext $commit $createnames $insertnames $logoff $logon $makeschema $nextnativeerror $rollback $rpcdefine $selectnames $updatenames $wherenames