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 InfoMaker.

The database parameters are described in alphabetical order following the table.

Database interface	DBParm parameters
ASE Sybase Adaptive Server® Enterprise Release The Release database parameter must be set to 15 or higher to use the ASE interface.	AppName Async 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 Host KeepAlive Language Locale Log	MaxConnect OJSyntax PacketSize (ASE, DIR, SNC, SYC) PBCatalogOwner PWDialog PWEncrypt 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 UTF8
DIR Sybase DirectConnect™	AppName Async Block (DirectConnect and Adaptive Server Enterprise) CharSet CommitOnDisconnect CursorUpdate DateTimeAllowed DBGetTime DBTextLimit DecimalSeparator DelimitIdentifier FormatArgsAsExp HostReqOwner KeepAlive	Locale LowerCaseIdent MaxConnect PacketSize (ASE, DIR, SNC, 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 TrimSpaces
I10 Informix	Async Client_Locale CommitOnDisconnect DateTimeAllowed DBGetTime Db_Locale DecimalSeparator DelimitIdentifier DisableBind EncryptionPass Hint	INET_DBPATH INET_PROTOCOL INET_SERVICE OJSyntax OnlineIndex PBCatalogOwner Scroll StmtCache StrByCharset ThreadSafe TrimSpaces
JDB JDBC	Async CommitOnDisconnect Date DateTime DBGetTime DelimitIdentifier DisableBind Driver FormatArgsAsExp IdentifierQuoteChar LoginTimeOut MsgTerse	MapDateToDateTime NumericFormat OJSyntax PBCatalogOwner Properties StaticBind TableCriteria Time TraceFile TrimSpaces URL
ODBC Using DBParms with ODBC These DBParm parameters are supported by the InfoMaker 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) CallEscape CommitOnDisconnect ConnectOption ConnectString CursorLib CursorLock CursorScroll Date DateTime DBGetTime DecimalSeparator DefaultProcOwner DelimitIdentifier DelimitIdentifierToDB DisableBind FormatArgsAsExp	IdentifierQuoteChar InsertBlock LoginTimeOut MsgTerse NumericFormat OJSyntax PacketSize (ODBC) PBCatalogOwner PBNewSPInvocation PBTrimCharColumns PBUseProcOwner RPCRebind SQLCache StaticBind StripParmNames TableCriteria Time TrimSpaces
OLE DB	Block (ODBC, OLE DB, Oracle, and SNC) CacheAuthentication CommitOnDisconnect DataLink DataSource DateFormat DateTimeFormat DecimalSeparator DelimitIdentifier DelimitIdentifierToDB DisableBind EncryptPassword IdentifierQuoteChar ImpersonationLevel IntegratedSecurity LCID Location	MaskPassword Mode OJSyntax PBCatalogOwner PBMaxBlobSize PBTrimCharColumns PersistEncrypted PersistSensitive Init_Prompt ProtectionLevel Provider ServiceComponents SPCache StaticBind TimeFormat Timeout TimeStamp
O90 Oracle9i O10 Oracle 10g ORA Oracle 11g	AppDriverName (ORA only) Async Block (ODBC, OLE DB, Oracle, and SNC) CnnPool (deprecated) CommitOnDisconnect ConnectAs CSIncr (ORA only) CSMax (ORA only) CSMin (ORA only) Date DateTime DBGetTime DecimalSeparator DelimitIdentifier DisableBind FoDelay FoDialog FoRetryCount FormatArgsAsExp HANotification (O10 and later) MixedCase NCharBind NCharLiteral (O10 and later)	NLS_Charset NumbersInternal ObjectMode OJSyntax PackageProcs PBCatalogOwner PoolCreator (ORA only) Pooling (ORA only) PoolPwd (ORA only) PWDialog QualifyPublic RTConnBalancing (ORA only) SPCache ServerName (ORA only) SessionHomogeneous (ORA only) StatementCache (O10 and later) StaticBind StrByCharset SvrFailover TableCriteria ThreadSafe Time TimeStamp TrimSpaces
SNC SQL Native Client for Microsoft SQL Server	AppName Block (ODBC, OLE DB, Oracle, and SNC) CommitOnDisconnect Database DataLink DateFormat DBTextLimit DecimalSeparator DelimitIdentifier DisableBind Encrypt FailoverPartner Host Identity	OJSyntax PacketSize (ASE, DIR, SNC, SYC) PBCatalogOwner PBMaxBlobSize PBMaxTextSize Provider ProviderString SPCache StaticBind TimeFormat Timeout TrimSpaces TrustedConnection TrustServerCertificate TimeStamp
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 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 Host KeepAlive Language Locale Log	MaxConnect OJSyntax PacketSize (ASE, DIR, SNC, SYC) PBCatalogOwner PWDialog PWEncrypt 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 UTF8

Database interface

DBParm parameters

ASE Sybase Adaptive Server® Enterprise

Release The Release database parameter must be set to 15 or higher to use the ASE interface.