DB2 V9.7 for Linux, UNIX, and Windows
DB2 V9.7 for Linux, UNIX, and Windows
使用数据源列的列名和目标列的列序号来创建 DB2BulkCopyColumnMapping，并将它添加至 DB2BulkCopyColumnMappingCollection。
[Visual Basic]
Public Function Add ( _
src As String, _
dest As Integer _
) As DB2BulkCopyColumnMapping
[C#]
public DB2BulkCopyColumnMapping Add(
string src,
int dest
)
[C++]
public:
DB2BulkCopyColumnMapping* Add (
String* src,
int dest
)
[JScript]
public function Add(
src : String,
dest : int
) : DB2BulkCopyColumnMapping已添加至 DB2BulkCopyColumnMappingCollection 的列映射。
[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", 0);
colMapCollection.Add("DEPTNAME", 1);
colMapCollection.Add("MANAGER", 3);
colMapCollection.Add("LOCATION", 4);
try
{
salesCopy.WriteToServer(reader);
salesCopy.Close();
}
catch (DB2Exception ex)
{
MessageBox.Show(ex.ToString(), "Exception");
}
}