| Object specific | |
| $authmode | The authentication mode to be used with this connection |
| $batchsize | The number of rows to retrieve simultaneously. Statement objects inherit this value. $batchsize is not supported by all databases in which case it reverts to 1 |
| $binaryfloat | If kTrue, Omnis Number floating dp columns are mapped to BINARY_FLOAT |
| $binarytoblob | If true, Omnis binary fields will be mapped to BLOB columns. If false, the LONG RAW data type is used |
| $booltonum | If true, Omnis boolean fields will be mapped to NUMBER(1,0) |
| $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 |
| $clientversion | Version number of the connected client library |
| $codepage | The code page used to interpret non-Unicode character data. A kUniType... constant that identifies an 8 bit character set (not kUniTypeUTF8) kUniTypeAnsiArabic kUniTypeAnsiBaltic kUniTypeAnsiCentralEuropean kUniTypeAnsiCyrillic kUniTypeAnsiGreek kUniTypeAnsiHebrew kUniTypeAnsiLatin1 kUniTypeAnsiThai kUniTypeAnsiTurkish kUniTypeAnsiVietnamese kUniTypeAuto kUniTypeBinary kUniTypeCharacter kUniTypeISO8859_1 kUniTypeISO8859_10 kUniTypeISO8859_11 kUniTypeISO8859_13 kUniTypeISO8859_14 kUniTypeISO8859_15 kUniTypeISO8859_16 kUniTypeISO8859_2 kUniTypeISO8859_3 kUniTypeISO8859_4 kUniTypeISO8859_5 kUniTypeISO8859_6 kUniTypeISO8859_7 kUniTypeISO8859_8 kUniTypeISO8859_9 kUniTypeNativeCharacters kUniTypeOEM kUniTypeUTF16 kUniTypeUTF16BE kUniTypeUTF16LE kUniTypeUTF32 kUniTypeUTF32BE kUniTypeUTF32LE kUniTypeUTF8 |
| $commitdelay | The delay (in milliseconds) between each $commit() retry |
| $commitretries | The number of times a $commit() operation will retry before failing |
| $credentials | Specifies the type of credentials to use for establishing the user session; kCredRDBMS or kCredEXT |
| $datetype | The Oracle data type used by $createnames() & $coltext() for Omnis Datetime fields |
| $debugfile | If assigned, the DAM writes debug information to the specified file. Set $debuglevel to enable/disable logging |
| $debuglevel | Specifies the level of debug information that will be written to $debugfile. Values 1-4 specify increasing amounts of debug information. Zero disables logging |
| $debugsize | The maximum size of $debugfile generated before automatic truncation occurs. Assigning zero disables truncation |
| $emptyasnull | If true, empty strings are inserted as NULL. If false, empty strings are inserted as chr(0) |
| $encoding | The Unicode encoding used by the database. A kSessionEncoding... constant (read-only) kSessionEncodingAnsi kSessionEncodingUtf16 kSessionEncodingUtf32 kSessionEncodingUtf8 |
| $falsetext | The text inserted when Omnis boolean (kFalse) fields are mapped to VARCHAR2 |
| $fetch64bitints | If kTrue, 64-bit integers are fetched into Omnis 64-bit Integer fields. If kFalse, they are fetched as 32-bit Integers and truncated accordingly |
| $filedirectory | The directory on the local filesystem where oversized CLOBs, BLOBs & BFILEs will be written |
| $filethreshold | The size in bytes above which CLOBs, BLOBs & BFILEs are no longer returned directly but instead written as files |
| $internalcharmapping | If true (default), character mapping to/from the Omnis character set is enabled |
| $longchartoclob | If true, Omnis character fields > $maxvarchar2 will be mapped to CLOB columns. If false, the LONG data type is used |
| $maxresultsetsize | The maximum size of a result set. Statement objects inherit this value. When a $fetch(kFetchAll) exceeds this value, the result set is trunacted and kFetchMemoryExceeded is returned |
| $maxvarchar2 | Threshold above which character columns are mapped to LONG/CLOB |
| $nationaltonclob | If true, Omnis national fields > $maxvarchar2 will be mapped to NCLOB. Character fields > $maxvarchar2 will be mapped to CLOB |
| $nationaltonvarchar | If true, Omnis national fields <= $maxvarchar2 will be mapped to NVARCHAR2. Character fields <= $maxvarchar2 will be mapped to VARCHAR2 |
| $nativewarncode | Code of reported warning |
| $nativewarntext | Warning message |
| $newpassword | If set, DAM will attempt to change the user's (expired) password during $logon() |
| $nullasempty | If true, nulls retrieved from Oracle will be treated as empty |
| $odbpsk | Pre-shared key for use with databridge encryption |
| $querytimeout | The time in seconds before an executing statement times-out (Linux only) |
| $quotedidentifier | If kTrue, table instances and session methods will generate quoted column & table name identifiers, thus preserving mixed-case names and names |
| $timezone | The session timezone- used to modify incoming/outgoing timestamps containing time zone attributes |
| $trackslowqueries | Queries running longer than the amount of seconds specified in this property will be reported as a slow running query to the trace log. Defaults to 0 (off) |
| $trailingspaces | If false, trailing spaces on data being inserted are stripped |
| $truetext | The text inserted when Omnis boolean (kTrue) fields are mapped to VARCHAR2 |
| $unicode | If kTrue, Unicode data types/mappings are used with character data. If kFalse, the DAM reverts to ANSI behaviour and the DAM will attempt to map any Unicode characters to the specified $codepage |
| $useprecision | If true, DAM attempts to map Oracle Number types to Omnis number (dp) |
| 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 |
| Object specific | |
| $endproxy | Terminates a proxy session |
| $getnames | Retrieves a list of TNS names defined in the local tnsnames.ora file |
| $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 ORACLE8 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 ORACLE8 statement object |
| $proxyas | Creates a proxy session based on the current connection |
| Standard | $begin $clear $coltext $commit $createnames $definelistorrow $insertnames $logoff $logon $makeschema $nextnativeerror $rollback $rpcdefine $selectnames $updatenames $wherenames |