DB2 V9.7 for Linux, UNIX, and Windows
DB2 V9.7 for Linux, UNIX, and Windows
初始化新的 DB2BulkCopyColumnMappingCollection 对象。
[Visual Basic]
Public Sub New
[C#]
public DB2BulkCopyColumnMappingCollection();
[C++]
public: DB2BulkCopyColumnMappingCollection();
[JScript]
public function DB2BulkCopyColumnMappingCollection();如果使用此构造函数创建 DB2BulkCopyColumnMappingCollection 实例，那么将需要添加列映射。可通过使用 Add 方法或 Insert 方法添加列映射。
[C#] 以下示例演示如何将 DB2DataReader 中的数据成批复制到 DEPARTMENT 表中。源表与目标表之间的列映射由 DB2BulkCopyColumnMappingCollection 实例定义。
[C#]
public static void copyIntoSales(DB2Connection conn, DB2DataReader reader)
{
DB2BulkCopy salesCopy = new DB2BulkCopy(conn);
salesCopy.DestinationTableName = "DEPARTMENT";
DB2BulkCopyColumnMappingCollection colMapCollection;
colMapCollection = new DB2BulkCopyColumnMappingCollection();
salesCopy.ColumnMappings = colMapCollection;
colMapCollection.Add("DEPTNUMB", "DEPTNO");
colMapCollection.Add("DEPTNAME", "DEPTNAME");
colMapCollection.Add("MANAGER", "ADMRDEPT");
colMapCollection.Add("LOCATION", "LOCATION");
try
{
salesCopy.WriteToServer(reader);
salesCopy.Close();
}
catch (DB2Exception ex)
{
MessageBox.Show(ex.ToString(), "Exception");
}
}