| Object specific | |
| $backendpid | The process ID of the backend server process handling 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 |
| $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 |
| $cannotify | While kTrue, the $notify() method is enabled. While kFalse, notifications are queued. |
| $char38touuid | If kTrue, Omnis character fields of length 38 are mapped to UUID |
| $char39tooid | If kTrue, Omnis character fields of length 39 are mapped to OID |
| $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 |
| $database | Name of the session database |
| $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 |
| $defaultdateisempty | If kTrue, fetched datetimes matching $defaultdate are treated as empty values |
| $encoding | The Unicode encoding used by the database. A kSessionEncoding... constant (read-only) kSessionEncodingAnsi kSessionEncodingUtf16 kSessionEncodingUtf32 kSessionEncodingUtf8 |
| $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 |
| $infinitydates | If kTrue, the date value '31 Dec 9999 23:59:59' maps to the special date value 'infinity' |
| $listenername | Registers a name for the $listen session (appears in the pg_stat_activity system table). |
| $logontimeout | Number of seconds before a connection attempt times out |
| $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 |
| $maxvarchar | The maximum size above which Omnis Character types are mapped to text |
| $numericprecision | The precision used when mapping the Omnis number (dp) type to 'numeric' |
| $odbpsk | Pre-shared key for use with databridge encryption |
| $options | Allows additional logon parameters to be specified |
| $pipelinemode | If kTrue, manual transactions are dispatched using pipeline mode. Requires libpq API v14 and later. |
| $port | The port number for the TCP/IP connection |
| $programname | Registers a name for the session (appears in the pg_stat_activity system table) |
| $protocolversion | Version of the protocol in use |
| $quotedidentifier | If kTrue, table instances and session methods will generate quoted column & table name identifiers, thus preserving mixed-case names and names |
| $readonly | If kTrue, manual transactions are read-only |
| $schema | The schema name to be used when qualifying table names |
| $sequencetoint | If kTrue, the Omnis Sequence type is mapped to INTEGER instead of SERIAL |
| $serializable | If kTrue, manual transactions will use Serializable isolation level |
| $service | Service name to use for additional connection parameters |
| $socket | The file descriptor number of the connection socket to the server. |
| $timezone | The time zone to be used when $usetimezone is kTrue |
| $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) |
| $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 |
| $usetimezone | If kTrue, date/time time zone delimiters are used |
| 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 | |
| $addcustomtype | Creates a custom datatype mapping for the specified field size |
| $cancel | Requests that the server abandon processing of the current command(s) |
| $clearcustomtypes | Clears the internal list of custom character types |
| $connectstatus | Returns the status of the current connection |
| $escapebinary | Escapes binary data for use as a quoted literal value within an SQL statement |
| $getssl | Returns kTrue if the connection is using SSL and optionally, info about the connection. Requires an SSL-enabled client library |
| $listen | Listens for the specified notification channel name and calls obj.$notify() when triggered |
| $lobclose | Closes the specified large object |
| $lobcreate | Creates a new large object, optionally using the specified OID |
| $lobexport | Exports the specified large object from the database into a local file |
| $lobimport | Imports the contents of a local file into a new large object, optionally using the specified OID |
| $lobopen | Opens an existing large object for reading or writing |
| $lobread | Reads data from an existing large object |
| $lobseek | Changes the current read/write position for the specified large object |
| $lobtell | Obtains the current read/write position for the specified large object |
| $lobtruncate | Resizes a large object to the specified length |
| $lobunlink | Unlinks the specified large object from the database |
| $lobwrite | Writes data to an existing large object |
| $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 POSTGRESQL 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 POSTGRESQL statement object |
| $notify | Called from a listener thread when the specified notification channel is triggered |
| $parameterstatus | Returns the current value of a server parameter setting |
| $pipelineresults | Fetches results of pipelined commands |
| $reset | Resets the current connection to the database server |
| $transactionstatus | Returns the current transaction status |
| $unlisten | Removes the specified notification channel from the listener queue |
| Standard | $begin $clear $coltext $commit $createnames $definelistorrow $insertnames $logoff $logon $makeschema $nextnativeerror $rollback $rpcdefine $selectnames $updatenames $wherenames |