Database parameters and supported database interfaces

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 following the table.

Database interface	DBParm parameters
ADO.NET	ADORelease CommandTimeout CommitOnDisconnect Database DataLink DataSource DateFormat DateTimeFormat DBConfigSection DecimalSeparator DefaultProcOwner DelimitIdentifier DisableBind IdentifierQuoteChar	Isolation Namespace NCharBind (Oracle only) OJSyntax PBCatalogOwner PBMaxBlobSize Provider ProviderString SPCache StaticBind TimeFormat Timeout TrimSpaces TrustedConnection
DIR Sybase DirectConnect™	AppName Async Block (DirectConnect and Adaptive Server Enterprise) CharSet CommitOnDisconnect CursorUpdate DateTimeAllowed DBGetTime DBTextLimit DecimalSeparator DelimitIdentifier FormatArgsAsExp HostReqOwner Language	Locale LowerCaseIdent MaxConnect PacketSize (DIR, 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
JDBC	Async CacheName CommitOnDisconnect Date DateTime DBGetTime DelimitIdentifier DisableBind Driver FormatArgsAsExp GetConnectionOption IdentifierQuoteChar JavaVM (JDB only) LoginTimeOut	MsgTerse NumericFormat OJSyntax PBCatalogOwner Properties ProxyUserName ReleaseConnectionOption StaticBind TableCriteria Time TraceFile TrimSpaces URL UseContextObject
ODBC Using DBParms with ODBC These database parameters are supported by the PowerBuilder ODBC interface only if both the ODBC driver you are using and the back-end DBMS support the feature	Async Block (ODBC, OLE DB, and Oracle) CacheName CallEscape CommitOnDisconnect ConnectOption ConnectString CursorLib CursorLock CursorScroll Date DateTime DBGetTime DecimalSeparator DefaultProcOwner DelimitIdentifier DisableBind FormatArgsAsExp GetConnectionOption IdentifierQuoteChar InsertBlock	LoginTimeOut MsgTerse NumericFormat ODBCU_CONLIB OJSyntax PacketSize (ODBC) PBCatalogOwner PBNewSPInvocation PBTrimCharColumns PBUseProcOwner ProxyUserName ReleaseConnectionOption RPCRebind SQLCache StaticBind StripParmNames TableCriteria Time TrimSpaces UseContextObject
OLE DB	BinTxtBlob Block (ODBC, OLE DB, and Oracle) CacheAuthentication CommitOnDisconnect DataLink DataSource DateFormat DateTimeFormat DecimalSeparator DelimitIdentifier DisableBind EncryptPassword IdentifierQuoteChar ImpersonationLevel Init_Prompt IntegratedSecurity LCID	Location MaskPassword Mode OJSyntax PBCatalogOwner PBMaxBlobSize PBTrimCharColumns PersistEncrypted PersistSensitive ProtectionLevel Provider ProviderString ReturnCommandHandle ServiceComponents StaticBind TimeFormat Timeout
O84 Oracle 8.x and Oracle8i O90 Oracle9i O10 Oracle 10g	Async BindSPInput BinTxtBlob Block (ODBC, OLE DB, and Oracle) CacheName CnnPool (O90 and later) CommitOnDisconnect ConnectAs (O90 and later) Date DateTime DBGetTime DecimalSeparator DelimitIdentifier DisableBind DisableUnicode (O84 only) FoDelay FoDialog FoRetryCount FormatArgsAsExp GetConnectionOption MaxFetchBuffer	MixedCase NCharBind (O90 and later) NumbersInternal ObjectMode OJSyntax OraMTSConFlgs PackageProcs PBCatalogOwner PWDialog PWExpDialog QualifyPublic ReleaseConnectionOption SQLCache StaticBind SvrFailover TableCriteria ThreadSafe Time TimeStamp (O90 and later) UseContextObject
SYC Sybase Adaptive Server® Enterprise Set Release The Release database parameter must be set to the version of your Open Client® software (11 or higher) to use DS_* and Sec_* parameters.	AppName Async BinTxtBlob 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 (DIR, SYC) PBCatalogOwner ProxyUserName PWDialog PWEncrypt PWExpDialog 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 StaticBind SvrFailover SystemProcs TableCriteria TrimSpaces UTF8
SYJ Sybase Adaptive Server Enterprise	Block (DirectConnect and Adaptive Server Enterprise) CacheName CursorUpdate DBTextLimit FormatArgsAsExp GetConnectionOption Log PBCatalogOwner	ProxyUserName ReleaseConnectionOption StaticBind SvrFailover SystemProcs TrimSpaces UseContextObject UTF8

Database interface

DBParm parameters

ADO.NET

ADORelease
CommandTimeout
CommitOnDisconnect
Database
DataLink
DataSource
DateFormat
DateTimeFormat
DBConfigSection
DecimalSeparator
DefaultProcOwner
DelimitIdentifier
DisableBind
IdentifierQuoteChar

Isolation
Namespace
NCharBind (Oracle only)
OJSyntax
PBCatalogOwner
PBMaxBlobSize
Provider
ProviderString
SPCache
StaticBind
TimeFormat
Timeout
TrimSpaces
TrustedConnection

DIR Sybase DirectConnect™

AppName
Async
Block (DirectConnect and Adaptive Server Enterprise)
CharSet
CommitOnDisconnect
CursorUpdate
DateTimeAllowed
DBGetTime
DBTextLimit
DecimalSeparator
DelimitIdentifier
FormatArgsAsExp
HostReqOwner
Language

Locale
LowerCaseIdent
MaxConnect
PacketSize (DIR, 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

JDBC

Async
CacheName
CommitOnDisconnect
Date
DateTime
DBGetTime
DelimitIdentifier
DisableBind
Driver
FormatArgsAsExp
GetConnectionOption
IdentifierQuoteChar
JavaVM (JDB only)
LoginTimeOut

MsgTerse
NumericFormat
OJSyntax
PBCatalogOwner
Properties
ProxyUserName
ReleaseConnectionOption
StaticBind
TableCriteria
Time
TraceFile
TrimSpaces
URL
UseContextObject

ODBC

Using DBParms with ODBC These database parameters are supported by the PowerBuilder ODBC interface only if both the ODBC driver you are using and the back-end DBMS support the feature

Async
Block (ODBC, OLE DB, and Oracle)
CacheName
CallEscape
CommitOnDisconnect
ConnectOption
ConnectString
CursorLib
CursorLock
CursorScroll
Date
DateTime
DBGetTime
DecimalSeparator
DefaultProcOwner
DelimitIdentifier
DisableBind
FormatArgsAsExp
GetConnectionOption
IdentifierQuoteChar
InsertBlock

LoginTimeOut
MsgTerse
NumericFormat
ODBCU_CONLIB
OJSyntax
PacketSize (ODBC)
PBCatalogOwner
PBNewSPInvocation
PBTrimCharColumns
PBUseProcOwner
ProxyUserName
ReleaseConnectionOption
RPCRebind
SQLCache
StaticBind
StripParmNames
TableCriteria
Time
TrimSpaces
UseContextObject

OLE DB

BinTxtBlob
Block (ODBC, OLE DB, and Oracle)
CacheAuthentication
CommitOnDisconnect
DataLink
DataSource
DateFormat
DateTimeFormat
DecimalSeparator
DelimitIdentifier
DisableBind
EncryptPassword
IdentifierQuoteChar
ImpersonationLevel
Init_Prompt
IntegratedSecurity
LCID

Location
MaskPassword
Mode
OJSyntax
PBCatalogOwner
PBMaxBlobSize
PBTrimCharColumns
PersistEncrypted
PersistSensitive
ProtectionLevel
Provider
ProviderString
ReturnCommandHandle
ServiceComponents
StaticBind
TimeFormat
Timeout

O84 Oracle 8.x and Oracle8i

O90 Oracle9i

O10 Oracle 10g

Async
BindSPInput
BinTxtBlob
Block (ODBC, OLE DB, and Oracle)
CacheName
CnnPool (O90 and later)
CommitOnDisconnect
ConnectAs (O90 and later)
Date
DateTime
DBGetTime
DecimalSeparator
DelimitIdentifier
DisableBind
DisableUnicode (O84 only)
FoDelay
FoDialog
FoRetryCount
FormatArgsAsExp
GetConnectionOption
MaxFetchBuffer

MixedCase
NCharBind (O90 and later)
NumbersInternal
ObjectMode
OJSyntax
OraMTSConFlgs
PackageProcs
PBCatalogOwner
PWDialog
PWExpDialog
QualifyPublic
ReleaseConnectionOption
SQLCache
StaticBind
SvrFailover
TableCriteria
ThreadSafe
Time
TimeStamp (O90 and later)
UseContextObject

SYC Sybase Adaptive Server® Enterprise

Set Release The Release database parameter must be set to the version of your Open Client® software (11 or higher) to use DS_* and Sec_* parameters.

AppName
Async
BinTxtBlob
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 (DIR, SYC)
PBCatalogOwner
ProxyUserName
PWDialog
PWEncrypt
PWExpDialog
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
StaticBind
SvrFailover
SystemProcs
TableCriteria
TrimSpaces
UTF8

SYJ Sybase Adaptive Server Enterprise

Block (DirectConnect and Adaptive Server Enterprise)
CacheName
CursorUpdate
DBTextLimit
FormatArgsAsExp
GetConnectionOption
Log
PBCatalogOwner

ProxyUserName
ReleaseConnectionOption
StaticBind
SvrFailover
SystemProcs
TrimSpaces
UseContextObject
UTF8