Object specific | |
$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 |
$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 |
$cterrorlayer | Layer at which error occurred |
$cterrornumber | Error number |
$cterrororigin | Origin of error |
$cterrorseverity | Severity of error |
$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 |
$encoding | The Unicode encoding used by the database. A kSessionEncoding... constant (read-only) kSessionEncodingAnsi kSessionEncodingUtf16 kSessionEncodingUtf32 kSessionEncodingUtf8 |
$encryptpassword | Use password encryption when logging on |
$failtimeout | Raise an error if a timeout occurs |
$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 |
$locale | The locale associated with this connection |
$logontimeout | Timeout in seconds for a logon |
$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 |
$moneydps | Number of decimal places used to display MONEY data |
$nationaltounichar | If kTrue, National character types are mapped to UNIVARCHAR (Utf-16) |
$nativewarntext | Information or warning generated by the last operation |
$odbpsk | Pre-shared key for use with databridge encryption |
$odbsocket | Server-side TCP socket used by a data bridge connection (read-only) |
$programname | Program name registered by Sybase |
$querytimeout | Timeout in seconds for a query |
$quotedidentifier | If kTrue, table instances and session methods will generate quoted column & table name identifiers, thus preserving mixed-case names and names |
$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 |
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 | |
$clearremotepasswords | $clearremotepasswords() Clear all passwords for remote server connections |
$getnames | Retrieves a list of directory service names defined in the local interfaces/sql.ini/freetds.conf 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 SYBASE 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 SYBASE statement object |
$setremotepassword | $setremotepassword(cServerName,cPassword) Set a password for a remote server connection |
Standard | $begin $clear $coltext $commit $createnames $definelistorrow $insertnames $logoff $logon $makeschema $nextnativeerror $rollback $rpcdefine $selectnames $updatenames $wherenames |