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.

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 Sybase 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

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

SNCSQL 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

RechecRows

SPCache

StaticBind

TimeFormat

Timeout

TrimSpaces

TrustedConnection

TrustServerCertificate

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

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 Sybase 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