Database parameters and supported database interfaces

ASE Sybase Adaptive Server® Enterprise

• AppName

• Async

• Block (DirectConnect and Adaptive Server Enterprise)

• CharSet

• CommitOnDisconnect

• CursorType

• CursorUpdate

• DateTimeAllowed

• DBGetTime

• DBTextLimit

• DelimitIdentifier

• DS_Alias

• DS_Copy

• DS_DitBase

• DS_Failover

• DS_Password

• DS_Principal

• DS_Provider

• DS_TimeLimit

• FoDialog

• FormatArgsAsExp

• Host

• KeepAlive

• Language

• Locale

• Log

• MaxConnect

• OJSyntax

• PacketSize (ASE, DIR, SNC, SYC)

• PBCatalogOwner

• PWDialog

• PWEncrypt

• Release

• Sec_Channel_Bind

• Sec_Confidential

• Sec_Cred_Timeout

• Sec_Data_Integrity

• Sec_Data_Origin

• Sec_Delegation

• Sec_Keytab_File

• Sec_Mechanism

• Sec_Mutual_Auth

• Sec_Network_Auth

• Sec_Replay_Detection

• Sec_Seq_Detection

• Sec_Server_Principal

• Sec_Sess_Timeout

• ShowTempTables

• StaticBind

• SvrFailover

• SystemProcs

• TableCriteria

• TrimSpaces

• UTF8

DIR Sybase DirectConnect™

• AppName

• Async

• Block (DirectConnect and Adaptive Server Enterprise)

• CharSet

• CommitOnDisconnect

• CursorUpdate

• DateTimeAllowed

• DBGetTime

• DBTextLimit

• DecimalSeparator

• DelimitIdentifier

• FormatArgsAsExp

• HostReqOwner

• KeepAlive

• Locale

• LowerCaseIdent

• MaxConnect

• PacketSize (ASE, DIR, SNC, SYC)

• PBCatalogOwner

• Request

• ShowWarnings

• SQLQualifiers

• StaticBind

• SystemOwner

• TableCriteria

• TrimSpaces

• TRS

• UseProcSyntax

• UTF8

IN9 Informix

• Async

• CommitOnDisconnect

• DateTimeAllowed

• DBGetTime

• DecimalSeparator

• DelimitIdentifier

• DisableBind

• INET_DBPATH

• INET_PROTOCOL

• INET_SERVICE

• OJSyntax

• Scroll

• ThreadSafe

• TrimSpaces

I10 Informix

• Async

• Client_Locale

• CommitOnDisconnect

• DateTimeAllowed

• DBGetTime

• Db_Locale

• DecimalSeparator

• DelimitIdentifier

• DisableBind

• EncryptionPass

• Hint

• INET_DBPATH

• INET_PROTOCOL

• INET_SERVICE

• OJSyntax

• OnlineIndex

• PBCatalogOwner

• Scroll

• StmtCache

• StrByCharset

• ThreadSafe

• TrimSpaces

JDB JDBC

• Async

• CommitOnDisconnect

• Date

• DateTime

• DBGetTime

• DelimitIdentifier

• DisableBind

• Driver

• FormatArgsAsExp

• IdentifierQuoteChar

• LoginTimeOut

• MsgTerse

• MapDateToDateTime

• NumericFormat

• OJSyntax

• PBCatalogOwner

• Properties

• StaticBind

• TableCriteria

• Time

• TraceFile

• TrimSpaces

• URL

ODBC

• Async

• Block (ODBC, OLE DB, Oracle, and SNC)

• CallEscape

• CommitOnDisconnect

• ConnectOption

• ConnectString

• CursorLib

• CursorLock

• CursorScroll

• Date

• DateTime

• DBGetTime

• DecimalSeparator

• DefaultProcOwner

• DelimitIdentifier

• DelimitIdentifierToDB

• DisableBind

• FormatArgsAsExp

• IdentifierQuoteChar

• InsertBlock

• LoginTimeOut

• MsgTerse

• NumericFormat

• OJSyntax

• PacketSize (ODBC)

• PBCatalogOwner

• PBNewSPInvocation

• PBTrimCharColumns

• PBUseProcOwner

• RPCRebind

• SQLCache

• StaticBind

• StripParmNames

• TableCriteria

• Time

• TrimSpaces

OLE DB

• Block (ODBC, OLE DB, Oracle, and SNC)

• CacheAuthentication

• CommitOnDisconnect

• DataLink

• DataSource

• DateFormat

• DateTimeFormat

• DecimalSeparator

• DelimitIdentifier

• DelimitIdentifierToDB

• DisableBind

• EncryptPassword

• IdentifierQuoteChar

• ImpersonationLevel

• IntegratedSecurity

• LCID

• Location

• MaskPassword

• Mode

• OJSyntax

• PBCatalogOwner

• PBMaxBlobSize

• PBTrimCharColumns

• PersistEncrypted

• PersistSensitive

• Init_Prompt

• ProtectionLevel

• Provider

• ServiceComponents

• SPCache

• StaticBind

• TimeFormat

• Timeout

O84 Oracle 8.x and Oracle8i

O90 Oracle9i

O10 Oracle 10g

• Async

• Block (ODBC, OLE DB, Oracle, and SNC)

• CnnPool (O90 and later)

• CommitOnDisconnect

• ConnectAs (O90 and later)

• Date

• DateTime

• DBGetTime

• DecimalSeparator

• DelimitIdentifier

• DisableBind

• DisableUnicode (O84 only)

• FoDelay

• FoDialog

• FoRetryCount

• FormatArgsAsExp

• HANotification (O10 only)

• MixedCase

• NCharBind (O90 and later)

• NLS_Charset (O90 and later)

• NumbersInternal

• ObjectMode

• OJSyntax

• PackageProcs

• PBCatalogOwner

• PWDialog

• QualifyPublic

• SPCache

• StatementCache (O10 only)

• StaticBind

• StrByCharset (O90 and later)

• SvrFailover

• TableCriteria

• ThreadSafe

• Time

• TimeStamp (O90 and later)

• TrimSpaces (O90 and later)

SNC SQL Native Client for Microsoft SQL Server

• AppName

• Block (ODBC, OLE DB, Oracle, and SNC)

• CommitOnDisconnect

• DataLink

• DateFormat

• DecimalSeparator

• DelimitIdentifier

• DisableBind

• Encrypt

• Host

• Identity

• OJSyntax

• PacketSize (ASE, DIR, SNC, SYC)

• PBCatalogOwner

• PBMaxBlobSize

• PBMaxTextSize

• ProviderString

• SPCache

• StaticBind

• TimeFormat

• Timeout

• TrimSpaces

• TrustedConnection

• TrustServerCertificate

SYC Sybase Adaptive Server® Enterprise

• AppName

• Async

• Block (DirectConnect and Adaptive Server Enterprise)

• CharSet

• CommitOnDisconnect

• CursorType

• CursorUpdate

• DateTimeAllowed

• DBGetTime

• DBTextLimit

• DelimitIdentifier

• DS_Alias

• DS_Copy

• DS_DitBase

• DS_Failover

• DS_Password

• DS_Principal

• DS_Provider

• DS_TimeLimit

• FoDialog

• FormatArgsAsExp

• Host

• KeepAlive

• Language

• Locale

• Log

• MaxConnect

• OJSyntax

• PacketSize (ASE, DIR, SNC, SYC)

• PBCatalogOwner

• PWDialog

• PWEncrypt

• Release

• Sec_Channel_Bind

• Sec_Confidential

• Sec_Cred_Timeout

• Sec_Data_Integrity

• Sec_Data_Origin

• Sec_Delegation

• Sec_Keytab_File

• Sec_Mechanism

• Sec_Mutual_Auth

• Sec_Network_Auth

• Sec_Replay_Detection

• Sec_Seq_Detection

• Sec_Server_Principal

• Sec_Sess_Timeout

• ShowTempTables

• StaticBind

• SvrFailover

• SystemProcs

• TableCriteria

• TrimSpaces

• UTF8