Database parameters and supported database interfaces
Contents
- AppDriverName
- AppName
- Async
- BindSPInput
- BinTxtBlob
- Block (ODBC, OLE DB, Oracle, and SNC)
- Block (Adaptive Server Enterprise)
- CacheAuthentication
- CacheGroup
- CacheName
- CallEscape
- CharSet
- Client_Locale
- CnnPool
- CommandTimeout
- CommitOnDisconnect
- ConnectAs
- ConnectOption
- ConnectString
- CSIncr
- CSMax
- CSMin
- CursorLib
- CursorLock
- CursorScroll
- CursorType
- CursorUpdate
- Database
- DataLink
- DataSource
- Date
- DateFormat
- DateTime
- DateTimeAllowed
- DateTimeFormat
- DBGetTime
- Db_Locale
- DBTextLimit
- DecimalSeparator
- DefaultProcOwner
- DelimitIdentifier
- DelimitIdentifierToDB
- DisableBind
- DS_Alias
- DS_Copy
- DS_DitBase
- DS_Failover
- DS_Password
- DS_Principal
- DS_Provider
- DS_TimeLimit
- Encrypt
- EncryptionPass
- EncryptPassword
- FailoverPartner
- FoDelay
- FoDialog
- FoRetryCount
- FormatArgsAsExp
- GenerateEqualsNull
- HANotification
- HighSeverityError
- Hint
- Host
- IdentifierQuoteChar
- Identity
- ImpersonationLevel
- INET_DBPATH
- INET_PROTOCOL
- INET_SERVICE
- Init_Prompt
- InsertBlock
- IntegratedSecurity
- Isolation
- KeepAlive
- Language
- LCID
- Locale
- Location
- Log
- LoginTimeOut
- LongConnection
- MaskPassword
- MaxConnect
- MaxFetchBuffer
- MixedCase
- Mode
- MsgTerse
- NCharBind
- NCharLiteral
- NLS_Charset
- NumbersInternal
- NumericFormat
- ObjectMode
- OJSyntax
- OnlineIndex
- OraMTSConFlgs (obsolete)
- PackageProcs
- PacketSize (ODBC)
- PacketSize (ASE, SNC, SYC)
- PBCatalogOwner
- PBMaxBlobSize
- PBMaxTextSize
- PBNewSPInvocation
- PBNoCatalog
- PBTrimCharColumns
- PBUseProcOwner
- PersistEncrypted
- PersistSensitive
- PoolCreator
- Pooling
- PoolPwd
- ProcedureInTransaction
- ProtectionLevel
- Provider
- ProviderString
- PWDialog
- PWEncrypt
- PWExpDialog
- QualifyPublic
- RecheckRows
- Release
- RPCRebind
- ReturnCommandHandle
- RTConnBalancing
- Scroll
- 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
- ServerName
- ServiceComponents
- SessionHomogeneous
- ShowTempTables
- SPCache
- SQLCache
- StatementCache
- StaticBind
- StmtCache
- StrByCharset
- StripParmNames
- SvrFailover
- SystemProcs
- TableCriteria
- ThreadSafe
- Time
- TimeFormat
- Timeout
- TimeStamp
- TrimSpaces
- TrustedConnection
- TrustServerCertificate
- UnicharBind
- UTF8
The following table lists each supported database interface and the
database parameters you can use with that interface in PowerBuilder. The
database parameters are described in alphabetical order after the
table.
|
Database interface |
DBParm parameters |
|
|---|---|---|
|
ADO.NET |
NCharBind (Oracle |
|
|
ASE SAP Adaptive Server Release The Release database |
ProxyUserName |
|
|
IN9 Informix |
||
|
I10 Informix |
||
|
ODBC Using DBParms with These database parameters are supported by the |
Block (ODBC, OLE DB, Oracle, and GetConnectionOption |
ODBCU_CONLIB ProxyUserName ReleaseConnectionOption UseContextObject |
|
OLE DB |
||
|
ORA Oracle (for 11g and later) O10 Oracle Oracle 9.2 |
AppDriverName Block (ODBC, OLE DB, Oracle, and CnnPool (obsolete) CSIncr (ORA only) CSMax (ORA only) CSMin (ORA only) GetConnectionOption HANotification (O10 and NCharLiteral (O10 and |
PoolCreator (ORA Pooling (ORA PoolPwd (ORA ReleaseConnectionOption RTConnBalancing (ORA ServerName (ORA SessionHomogeneous (ORA StatementCache (O10 and UseContextObject |
|
SNC SQL Native Client for Microsoft SQL MSOLEDBSQL Microsoft OLE DB Driver for SQL |
||
|
SYC SAP Adaptive Server Enterprise Set The Release database parameter must be set to |
ProxyUserName |