DB2®BulkCopyColumnMappingCollection.RemoveAt Method

Removes the DB2BulkCopyColumnMapping at the specified index position from the DB2BulkCopyColumnMappingCollection.

Namespace:: IBM.Data.DB2
Assembly:: IBM.Data.DB2 (in IBM.Data.DB2.dll)

Syntax


[Visual Basic]
Public Sub RemoveAt ( index As Integer )
[C#]
public void RemoveAt(int index)
[C++]
public:
void RemoveAt (int index)
[JScript]
public function RemoveAt (
          index : int
)

Parameters

index: The zero-based index position in the DB2BulkCopyColumnMappingCollection from where the DB2BulkCopyColumnMapping object is to be removed.

Remarks

If you need to perform multiple bulk copies, it would be more efficient to use a single DB2BulkCopy instance than to create a new instance for each bulk copy operation. When performing multiple bulk copy operations, use the RemoveAt method to remove selected column mappings (after running the DB2BulkCopy.WriteToServer method for the previous operation) before defining new column mappings for the next bulk copy operation. You can also use the Clear method to remove all existing column mappings.