Class Db2ConnectionManager

Connection manager of a ETLBox connection to a Db2 Server. Uses the official Db2 ADO.NET driver for .NET Core.

Inheritance

System.Object

DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>

Db2ConnectionManager

Implements

IConnectionManager

System.IDisposable

Inherited Members

DbConnectionManager<DB2Connection>.DbConnection

DbConnectionManager<DB2Connection>.MaxLoginAttempts

DbConnectionManager<DB2Connection>.LeaveOpen

DbConnectionManager<DB2Connection>.ConnectionString

DbConnectionManager<DB2Connection>.State

DbConnectionManager<DB2Connection>.Transaction

DbConnectionManager<DB2Connection>.IsInBulkInsert

DbConnectionManager<DB2Connection>.PP

DbConnectionManager<DB2Connection>.SupportComputedColumns

DbConnectionManager<DB2Connection>.IsOdbcOrOleDbConnection

DbConnectionManager<DB2Connection>.DoPrepareCommand

DbConnectionManager<DB2Connection>.ReadTableDefinition(ObjectNameDescriptor)

DbConnectionManager<DB2Connection>.CheckIfTableOrViewExists(String)

DbConnectionManager<DB2Connection>.CreateCommand(String, IEnumerable<QueryParameter>)

DbConnectionManager<DB2Connection>.ExecuteNonQuery(String, IEnumerable<QueryParameter>)

DbConnectionManager<DB2Connection>.ExecuteScalar(String, IEnumerable<QueryParameter>)

DbConnectionManager<DB2Connection>.ExecuteReader(String, IEnumerable<QueryParameter>)

DbConnectionManager<DB2Connection>.BeginTransaction(IsolationLevel)

DbConnectionManager<DB2Connection>.BeginTransaction()

DbConnectionManager<DB2Connection>.CommitTransaction()

DbConnectionManager<DB2Connection>.RollbackTransaction()

DbConnectionManager<DB2Connection>.CloneIfAllowed()

DbConnectionManager<DB2Connection>.Open()

DbConnectionManager<DB2Connection>.CreateDbConnection()

DbConnectionManager<DB2Connection>.Close()

DbConnectionManager<DB2Connection>.CloseIfAllowed()

DbConnectionManager<DB2Connection>.Dispose(Boolean)

DbConnectionManager<DB2Connection>.Dispose()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: ETLBox.Connection

Assembly: ETLBox.Db2.dll

Syntax

public class Db2ConnectionManager : DbConnectionManager<DB2Connection>, IConnectionManager, IDisposable

Examples

var db2Connection = new Db2ConnectionManager("Data Source=.;");

Constructors

Db2ConnectionManager()

Declaration

public Db2ConnectionManager()

Db2ConnectionManager(Db2ConnectionString)

Declaration

public Db2ConnectionManager(Db2ConnectionString connectionString)

Parameters

Type	Name	Description
Db2ConnectionString	connectionString

Db2ConnectionManager(String)

Declaration

public Db2ConnectionManager(string connectionString)

Parameters

Type	Name	Description
System.String	connectionString

Properties

ConnectionManagerType

The database type for the connection manager.

Declaration

public override ConnectionManagerType ConnectionManagerType { get; }

Property Value

Type	Description
ConnectionManagerType

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.ConnectionManagerType

MaxParameterAmount

returns the maximum amount of parameters that ca be passed into a sql query.

Declaration

public override int MaxParameterAmount { get; }

Property Value

Type	Description
System.Int32

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.MaxParameterAmount

QB

The quotation begin character that is used in the database. E.g. SqlServer uses: '[' and Postgres: '"'

Declaration

public override string QB { get; }

Property Value

Type	Description
System.String

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.QB

QE

The quotation end character that is used in the database. E.g. SqlServer uses: ']' and Postgres: '"'

Declaration

public override string QE { get; }

Property Value

Type	Description
System.String

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.QE

SupportDatabases

Indicates if database server does support multiple databases. A database in ETLBox means a schema in MySql.

Declaration

public override bool SupportDatabases { get; }

Property Value

Type	Description
System.Boolean

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.SupportDatabases

SupportProcedures

Declaration

public override bool SupportProcedures { get; }

Property Value

Type	Description
System.Boolean

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.SupportProcedures

SupportSchemas

Indicates if the database supports schemas In MySql, this is false because the schema here is a database in ETLBox. Use SupportDatabases instead

Declaration

public override bool SupportSchemas { get; }

Property Value

Type	Description
System.Boolean

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.SupportSchemas

Methods

AfterBulkInsert(String)

Called after every bulk insert of a batch

Declaration

public override void AfterBulkInsert(string tableName)

Parameters

Type	Name	Description
System.String	tableName	Destination table name

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.AfterBulkInsert(System.String)

BeforeBulkInsert(String)

Called before every bulk insert of a batch

Declaration

public override void BeforeBulkInsert(string tableName)

Parameters

Type	Name	Description
System.String	tableName	Destination table name

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.BeforeBulkInsert(System.String)

BulkDelete(ITableData)

Performs a bulk delete

Declaration

public override void BulkDelete(ITableData data)

Parameters

Type	Name	Description
ITableData	data	Batch of data

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.BulkDelete(ETLBox.ControlFlow.ITableData)

BulkInsert(ITableData)

Performs a bulk insert

Declaration

public override void BulkInsert(ITableData data)

Parameters

Type	Name	Description
ITableData	data	Batch of data

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.BulkInsert(ETLBox.ControlFlow.ITableData)

BulkSelect(ITableData, ICollection<String>, Action, Action, Action<Object>[])

Declaration

public override void BulkSelect(ITableData data, ICollection<string> selectColumnNames, Action beforeRowReadAction, Action afterRowReadAction, params Action<object>[] rowActions)

Parameters

Type	Name	Description
ITableData	data
System.Collections.Generic.ICollection<System.String>	selectColumnNames
System.Action	beforeRowReadAction
System.Action	afterRowReadAction
System.Action<System.Object>[]	rowActions

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.BulkSelect(ETLBox.ControlFlow.ITableData, System.Collections.Generic.ICollection<System.String>, System.Action, System.Action, System.Action<System.Object>[])

BulkUpdate(ITableData, ICollection<String>, ICollection<String>)

Declaration

public override void BulkUpdate(ITableData data, ICollection<string> setColumnNames, ICollection<string> joinColumnNames)

Parameters

Type	Name	Description
ITableData	data
System.Collections.Generic.ICollection<System.String>	setColumnNames
System.Collections.Generic.ICollection<System.String>	joinColumnNames

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.BulkUpdate(ETLBox.ControlFlow.ITableData, System.Collections.Generic.ICollection<System.String>, System.Collections.Generic.ICollection<System.String>)

CleanUpBulkInsert(String)

Called after the whole bulk insert operation (all batches)

Declaration

public override void CleanUpBulkInsert(string tablename)

Parameters

Type	Name	Description
System.String	tablename

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.CleanUpBulkInsert(System.String)

Clone()

Cretes a clone of the current connection manager

Declaration

public override IConnectionManager Clone()

Returns

Type	Description
IConnectionManager	A instance copy of the current connection manager

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.Clone()

PrepareBulkInsert(String)

Called before the whole bulk insert operation (all batches)

Declaration

public override void PrepareBulkInsert(string tablename)

Parameters

Type	Name	Description
System.String	tablename

Overrides

ETLBox.Connection.DbConnectionManager<IBM.Data.DB2.Core.DB2Connection>.PrepareBulkInsert(System.String)

Implements

IConnectionManager

System.IDisposable