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

Database interface	DBParm parameters
ADO.NET	ADORelease BindSPInput CommandTimeout CommitOnDisconnect Database DataLink DataSource DateFormat DateTimeFormat DBConfigSection DecimalSeparator DefaultProcOwner DelimitIdentifier DisableBind GenerateEqualsNull IdentifierQuoteChar Isolation	Namespace NCharBind (Oracle only) OJSyntax PBCatalogOwner PBMaxBlobSize Provider ProviderString RecheckRows SPCache StaticBind TimeFormat Timeout TrimSpaces TrustedConnection
ASE SAP Adaptive Server® Enterprise Release The Release database parameter must be set to 15 or higher to use the ASE interface.	AppName Async BinTxtBlob Block (DirectConnect and Adaptive Server Enterprise) CharSet CommitOnDisconnect CursorType CursorUpdate DateTimeAllowed DBGetTime DBTextLimit DelimitIdentifier DisableBind DS_Alias DS_Copy DS_DitBase DS_Failover DS_Password DS_Principal DS_Provider DS_TimeLimit FoDialog FormatArgsAsExp GenerateEqualsNull Host KeepAlive Language Locale Log MaxConnect	OJSyntax PacketSize (ASE, DIR, SNC, 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 ShowTempTables StaticBind SvrFailover SystemProcs TableCriteria TrimSpaces UnicharBind UTF8
DIR Sybase DirectConnect™	AppName Async Block (DirectConnect and Adaptive Server Enterprise) CharSet CommitOnDisconnect CursorUpdate DateTimeAllowed DBGetTime DBTextLimit DecimalSeparator DelimitIdentifier FormatArgsAsExp GenerateEqualsNull HostReqOwner Language	Locale LowerCaseIdent MaxConnect PacketSize (ASE, DIR, SNC, SYC) PBCatalogOwner Request ShowWarnings SQLQualifiers StaticBind SystemOwner TableCriteria TrimSpaces TRS UseProcSyntax UTF8
IN9 Informix	Async BinTxtBlob CommitOnDisconnect DateTimeAllowed DBGetTime DecimalSeparator DelimitIdentifier DisableBind	GenerateEqualsNull INET_DBPATH INET_PROTOCOL INET_SERVICE OJSyntax Scroll ThreadSafe TrimSpaces
I10 Informix	Async BinTxtBlob Client_Locale CommitOnDisconnect DateTimeAllowed DBGetTime Db_Locale DecimalSeparator DelimitIdentifier DisableBind EncryptionPass Hint	GenerateEqualsNull INET_DBPATH INET_PROTOCOL INET_SERVICE OJSyntax OnlineIndex PBCatalogOwner Scroll StmtCache StrByCharset ThreadSafe TrimSpaces
JDBC	Async CacheName CommitOnDisconnect Date DateTime DBGetTime DelimitIdentifier DisableBind Driver FormatArgsAsExp GenerateEqualsNull GetConnectionOption IdentifierQuoteChar LoginTimeOut MapDateToDateTime	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, Oracle, and SNC) CacheName CallEscape CommitOnDisconnect ConnectOption ConnectString CursorLib CursorLock CursorScroll Date DateTime DBGetTime DecimalSeparator DefaultProcOwner DelimitIdentifier DelimitIdentifierToDB DisableBind FormatArgsAsExp GenerateEqualsNull 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, Oracle, and SNC) CacheAuthentication CommitOnDisconnect DataLink DataSource DateFormat DateTimeFormat DecimalSeparator DelimitIdentifier DelimitIdentifierToDB DisableBind EncryptPassword GenerateEqualsNull IdentifierQuoteChar ImpersonationLevel Init_Prompt IntegratedSecurity LCID	Location MaskPassword Mode OJSyntax PBCatalogOwner PBMaxBlobSize PBTrimCharColumns PersistEncrypted PersistSensitive ProtectionLevel Provider ProviderString RecheckRows ReturnCommandHandle ServiceComponents SPCache StaticBind TimeFormat Timeout TimeStamp
ORA Oracle 11g O10 Oracle 10g Oracle 9.2 or later databases	AppDriverName (ORA only) Async BindSPInput BinTxtBlob Block (ODBC, OLE DB, Oracle, and SNC) CacheName CnnPool (deprecated) CommitOnDisconnect ConnectAs CSIncr (ORA only) CSMax (ORA only) CSMin (ORA only) Date DateTime DBGetTime DecimalSeparator DelimitIdentifier DisableBind FoDelay FoDialog FoRetryCount FormatArgsAsExp GenerateEqualsNull GetConnectionOption HANotification (O10 and later) MaxFetchBuffer MixedCase NCharBind NCharLiteral (O10 and later)	NLS_Charset NumbersInternal ObjectMode OJSyntax OraMTSConFlgs PackageProcs PBCatalogOwner PBNoCatalog PoolCreator (ORA only) Pooling (ORA only) PoolPwd (ORA only) PWDialog PWExpDialog QualifyPublic ReleaseConnectionOption RTConnBalancing (ORA only) SPCache ServerName (ORA only) SessionHomogeneous (ORA only) StatementCache (O10 and later) StaticBind StrByCharset SvrFailover TableCriteria ThreadSafe Time TimeStamp TrimSpaces UseContextObject
SNC SQL Native Client for Microsoft SQL Server	AppName BindSPInput BindSPInput BinTxtBlob Block (ODBC, OLE DB, Oracle, and SNC) CommitOnDisconnect Database DataLink DateFormat DBTextLimit DecimalSeparator DelimitIdentifier DisableBind Encrypt FailoverPartner GenerateEqualsNull HighSeverityError Host	Identity NCharBind OJSyntax PacketSize (ASE, DIR, SNC, SYC) PBCatalogOwner PBMaxBlobSize PBMaxTextSize Provider ProviderString RecheckRows SPCache StaticBind TimeFormat Timeout TimeStamp TrimSpaces TrustedConnection TrustServerCertificate
SYC SAP 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 DisableBind DS_Alias DS_Copy DS_DitBase DS_Failover DS_Password DS_Principal DS_Provider DS_TimeLimit FoDialog FormatArgsAsExp GenerateEqualsNull Host KeepAlive Language Locale Log	MaxConnect OJSyntax PacketSize (ASE, DIR, SNC, 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 ShowTempTables StaticBind SvrFailover SystemProcs TableCriteria TrimSpaces UnicharBind UTF8
SYJ SAP Adaptive Server Enterprise	Block (DirectConnect and Adaptive Server Enterprise) CacheName CursorUpdate DBTextLimit FormatArgsAsExp GenerateEqualsNull GetConnectionOption Log PBCatalogOwner	ProxyUserName ReleaseConnectionOption StaticBind SvrFailover SystemProcs TrimSpaces UseContextObject UnicharBind UTF8

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 12.6

August 14, 2023

Was this article helpful?

Database parameters and supported database interfaces – PB Docs 126

Database parameters and supported database interfaces

My Website Links