dotConnect for DB2 Documentation
Devart.Data.DB2 Namespace / DB2ConnectionStringBuilder Class
Properties Methods

In This Topic
    DB2ConnectionStringBuilder Class Members
    In This Topic

    The following tables list the members exposed by DB2ConnectionStringBuilder.

    Public Constructors
     NameDescription
    Public ConstructorDB2ConnectionStringBuilder ConstructorOverloaded. Initializes a new instance of the DB2ConnectionStringBuilder class.  
    Top
    Public Properties
     NameDescription
    Public PropertyAuthenticationGets or sets the type of authentication to be used.  
    Public PropertyCaptureModeDetermines if dynamically executed statements are captured for client optimization using pureQuery.  
    Public PropertyClientAccountingStringGets or sets the client accounting string.  
    Public PropertyClientApplicationNameGets or sets the client application name.  
    Public PropertyClientEncAlgDetermines whether AES encryption is being used.  
    Public PropertyClientUserIDGets or sets the client user ID string.  
    Public PropertyClientWorkstationNameGets or sets the name of the client workstation.  
    Public PropertyCLISchemaGets or sets the value indicating the schema to be used. When this keyword is set, the system catalog tables will not be queried to generate the result sets. The static tables created using the db2ocat tool will be queried instead.  
    Public PropertyCodePageGets or sets the current Encoding's code page identifier.  
    Public PropertyCollectionGets or sets the collection name, where collection name is the qualifier of the package name (collection.rootPkgName), to be used by pureQuery when executionMode is set to static.  
    Public PropertyConcurrentAccessResolutionSpecifies the concurrent access resolution to use.  
    Public PropertyConnectionLifetimeGets or sets time span in seconds for connection to live.  
    Public PropertyConnectionStringGets or sets the connection string associated with the System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public PropertyConnectNodeNumberSpecifies the database partition server to connect to.  
    Public PropertyConnectTimeoutGets or sets the time the application should wait for a connection.  
    Public PropertyConnStrPwdEncryptDetermines whether the password specified in the connection string is stored encrypted in memory.  
    Public PropertyConvertToLongDetermines whether varchar inputs should be reported as long varchar.  
    Public PropertyCountGets the current number of keys that are contained within the System.Data.Common.DbConnectionStringBuilder.ConnectionString property. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public PropertyCurrentPackageSetGets or sets the schema name for selecting the package to use for subsequent SQL statements.  
    Public PropertyCurrentSchemaGets or sets the current schema name that is used for all unqualified SQL objects accessed via the connection  
    Public PropertyDatabaseGets or sets the name of the database to connect to.  
    Public PropertyDB2ExplainDetermines whether the server will generate Explain snapshot and/or Explain table information.  
    Public PropertyDBNameGets or sets the database name.  
    Public PropertyDefaultCommandTimeoutGets or sets the time in seconds to wait while trying to execute a command before terminating the attempt and generating an error.  
    Public PropertyDelimIdentSpecifies whether any string within double quotes (") is treated as an identifier, and any string within single quotes (') is treated as a string literal.  
    Public PropertyDisableCursorHoldDetermines the effect of a transaction completion on open cursors.  
    Public PropertyEnlistGets or sets a Boolean value that indicates whether the connection is automatically enlisted in the current transaction context.  
    Public PropertyEnsureDefaultDFRMSpecifies whether the DB2Connection.Open method will attempt to explicitly set the rounding mode to ROUND_HALF_EVEN.  
    Public PropertyExecutionModeDetermines whether previously captured statements should be executed statically for client optimization using pureQuery.  
    Public PropertyFitHighPrecisionTypeGets or sets the type of precision to use.  
    Public PropertyGraphicSpecifies if GRAPHIC (double-byte character) is returned as a supported SQL data type and what unit is used to report GRAPHIC column length.  
    Public PropertyHostVarParametersDetermines whether the support for host variables is enabled.  
    Public PropertyInitializationCommandSpecifies a data source-specific command that should be executed immediately after establishing the connection. (Inherited from Devart.Common.DbConnectionStringBuilder)
    Public PropertyInstanceGets or sets the instance name for a local IPC connection.  
    Public PropertyInterruptGets or sets the interrupt processing mode.  
    Public PropertyIsFixedSizeOverridden. Returns true.  
    Public PropertyIsolationLevelGets or sets the isolation level for the connection.  
    Public PropertyIsReadOnlyGets a value that indicates whether the System.Data.Common.DbConnectionStringBuilder is read-only. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public PropertyItemOverridden. Returns the value of given key.  
    Public PropertyKeysOverridden. Collection of keys in the DB2ConnectionStringBuilder.  
    Public PropertyMapDateDefines whether the DATE types should be reported as a different data type.  
    Public PropertyMapTimeDefines whether the TIME types should be reported as a different data type.  
    Public PropertyMapTimestampDefines whether the TIMESTAMP types should be reported as a different data type.  
    Public PropertyMaxPoolSizeThe maximum number of connections allowed in the pool.  
    Public PropertyMinPoolSizeThe minimum number of connections allowed in the pool.  
    Public PropertyPasswordGets or sets the user's password to connect.  
    Public PropertyPersistSecurityInfoGets or sets a value indicating whether password is stored in connection string after connection is opened.  
    Public PropertyPoolingGets or sets pooling mode.  
    Public PropertyProgramIdSets a user-defined character string, that associates an application with a connection.  
    Public PropertyProgramNameSets the application name, which is used to identify the application at the server when monitoring.  
    Public PropertyPureQueryXMLGets or sets the file name and path of the capture file.  
    Public PropertyRetrieveXmlInBinaryFormatDetermines whether the XML data should be retrieved in a binary format.  
    Public PropertyRetryParameterBindingOnErrorIndicates whether the provider will re-execute failed statements.  
    Public PropertyRootPkgNameGets or sets the package identifier for the package name (collection.rootPkgName) to be used by pureQuery when ExecutionMode is set to static.  
    Public PropertyRunOnceCommandSpecifies a data source-specific command that should be executed immediately after first establishing the connection. Unlike InitializationCommand, this command is not executed when a connection is taken from the pool. (Inherited from Devart.Common.DbConnectionStringBuilder)
    Public PropertySchemaListGets or sets the list of schemas to use.  
    Public PropertySecurityGets or sets the security type being used.  
    Public PropertyServerGets or sets the host and port to connect to. For example, "db2server:5000". Port may be omitted.  
    Public PropertyServerTypeThis property applies to UniData® and UniVerse data servers only. Indicates whether the connection is to be made to UniData or UniVerse.  
    Public PropertySessionTimeZoneGets or sets the time zone at session level on the server.  
    Public PropertySSLClientKeystashGets or sets the name of the SSL stash (.sth) file used for an SSL connection.  
    Public PropertySSLClientKeystoredbGets or sets the name of the SSL key database file used for an SSL connection.  
    Public PropertyStatementConcentratorDetermines whether statement concentrator literals are enabled.  
    Public PropertyStaticLatchDetermines whether to enable static blocking.  
    Public PropertySysSchemaGets or sets an alternative schema to be searched.  
    Public PropertyTableTypeGets or sets the list of table types, which must be available via the connection.  
    Public PropertyTargetPrincipalGets or sets the fully qualified Kerberos principal name of the DB2® instance owner for a target server.  
    Public PropertyTraceFileGets or sets the name of a file to which all the connection trace information is written.  
    Public PropertyTransactionScopeLocalEnables support for non-distributed transactions in the TransactionScope implementation.  
    Public PropertyTrustedContextSystemPasswordGets or sets the password for the SYSTEM AUTHID of the trusted context.  
    Public PropertyTrustedContextSystemUserIDGets or sets the trusted context SYSTEM AUTHID for the connection.  
    Public PropertyUserIDGets or sets the name of the user to connect.  
    Public PropertyValidateConnectionIndicates whether to validate connections that are being taken from the pool.  
    Public PropertyValuesOverridden. Collection of values in the DB2ConnectionStringBuilder.  
    Public PropertyWalletIDGets or sets the encryption key wallet ID for U2 Data Server.  
    Public PropertyWalletPwdGets or sets the encryption key wallet password for U2 Data Server.  
    Top
    Public Methods
     NameDescription
    Public MethodAddAdds an entry with the specified key and value into the System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public MethodClearOverridden. Sets all DB2ConnectionStringBuilder properties to default values.  
    Public MethodContainsKeyOverridden. Indicates whether specified key is set in the DB2ConnectionStringBuilder object.  
    Public MethodEquivalentToOverloaded. Compares the specified connection information in this Devart.Common.DbConnectionStringBuilder object with the specified connection information in the supplied Devart.Common.DbConnectionStringBuilder object. (Inherited from Devart.Common.DbConnectionStringBuilder)
    Public MethodRemoveOverridden. Sets value of the specified key to default.  
    Public MethodShouldSerializeOverridden. Determines whether the key will be serialized if required.  
    Public MethodToStringReturns the connection string associated with this System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public MethodTryGetValueOverridden. Attempts to get a key value.  
    Top
    See Also

    Reference

    DB2ConnectionStringBuilder Class
    Devart.Data.DB2 Namespace
    ConnectionString Property

     

     

    © 2013 - 2024 Devart. All Rights Reserved.

    Send Feedback