Table of Contents
- Database parameters and supported database interfaces
-
- ADORelease
- AppDriverName
- AppName
- Async
- BindSPInput
- BinTxtBlob
- Block (ODBC, OLE DB, Oracle, and SNC)
- Block (DirectConnect and Adaptive Server Enterprise)
- CacheAuthentication
- CacheName (obsolete)
- 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
- DBConfigSection
- DBGetTime
- Db_Locale
- DBTextLimit
- DecimalSeparator
- DefaultProcOwner
- DelimitIdentifier
- DelimitIdentifierToDB
- DisableBind
- Driver
- 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
- GetConnectionOption (obsolete)
- HANotification
- HighSeverityError
- Hint
- Host
- HostReqOwner
- IdentifierQuoteChar
- Identity
- ImpersonationLevel
- INET_DBPATH
- INET_PROTOCOL
- INET_SERVICE
- Init_Prompt
- InsertBlock
- IntegratedSecurity
- Isolation
- KeepAlive
- Language
- LCID
- Locale
- Location
- Log
- LoginTimeOut
- LowerCaseIdent
- MapDateToDateTime
- MaskPassword
- MaxConnect
- MaxFetchBuffer
- MixedCase
- Mode
- MsgTerse
- Namespace
- NCharBind
- NCharLiteral
- NLS_Charset
- NumbersInternal
- NumericFormat
- ObjectMode
- ODBCU_CONLIB (obsolete)
- OJSyntax
- OnlineIndex
- OraMTSConFlgs (obsolete)
- PackageProcs
- PacketSize (ODBC)
- PacketSize (ASE, DIR, SNC, SYC)
- PBCatalogOwner
- PBMaxBlobSize
- PBMaxTextSize
- PBNewSPInvocation
- PBNoCatalog
- PBTrimCharColumns
- PBUseProcOwner
- PersistEncrypted
- PersistSensitive
- PoolCreator
- Pooling
- PoolPwd
- Properties
- ProtectionLevel
- Provider
- ProviderString
- ProxyUserName (obsolete)
- PWDialog
- PWEncrypt
- PWExpDialog
- QualifyPublic
- RecheckRows
- Release
- ReleaseConnectionOption (obsolete)
- Request
- 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
- ShowWarnings
- SPCache
- SQLCache
- SQLQualifiers
- StatementCache
- StaticBind
- StmtCache
- StrByCharset
- StripParmNames
- SvrFailover
- SystemOwner
- SystemProcs
- TableCriteria
- ThreadSafe
- Time
- TimeFormat
- Timeout
- TimeStamp
- TraceFile
- TrimSpaces
- TrustedConnection
- TrustServerCertificate
- TRS
- UnicharBind
- URL
- UseContextObject (obsolete)
- UseProcSyntax
- UTF8
About this chapter
This chapter describes the syntax and use of each database parameter that you can set in PowerBuilder.
Setting database parameters in code
Use the Preview page of the Database Connection Profile dialog box to ensure that you are using the correct syntax in code. Most boolean database parameters can be turned on using any of the values true, Yes, or 1, and turned off using false, No, or 0. Numeric values for database parameters must not be enclosed in quotes.
