Database Parameters

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
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
DBConfigSection
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
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
LongConnection
LowerCaseIdent
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
ProcedureInTransaction
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
TrimSpaces
TrustedConnection
TrustServerCertificate
TRS
UnicharBind
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.