DB2 V9.7 for Linux, UNIX, and Windows
DB2 V9.7 for Linux, UNIX, and Windows
从数据源中复制的列的名称。
[Visual Basic]
Public Property SourceColumn As String
[C#]
public string SourceColumn {get; set;}
[C++]
public: __property String* get_SourceColumn();
public: __property void set_SourceColumn(String*);
[JScript]
public function get SourceColumn() : String;
public function set SourceColumn(String);源列名的字符串值。
如果多次设置了源列值（例如，将值多次添加至 SourceColumn 或 SourceOrdinal 属性，或者对这两个属性中的每个属性至少指定了某个值一次），那么将在 Add 方法中使用最后设置的值。
salesCopy.ColumnMappings.SourceColumn= "\"LoCaTion\""; [C#] 以下示例演示如何将 DB2DataReader 中的数据成批复制到 DEPARTMENT 表中。源表和目标表之间的列映射由 SourceColumn 和 DestinationColumn 属性在 DB2BulkCopyColumnMapping 实例中定义。
[C#]
public static void copyIntoSales(DB2Connection conn, DB2DataReader reader)
{
DB2BulkCopy salesCopy = new DB2BulkCopy(conn);
salesCopy.DestinationTableName = "DEPARTMENT";
DB2BulkCopyColumnMapping colMapDeptNum = new DB2BulkCopyColumnMapping();
DB2BulkCopyColumnMapping colMapDeptNme = new DB2BulkCopyColumnMapping();
DB2BulkCopyColumnMapping colMapDeptMgr = new DB2BulkCopyColumnMapping();
DB2BulkCopyColumnMapping colMapDeptLoc = new DB2BulkCopyColumnMapping();
colMapDeptNum.DestinationColumn = "DEPTNO";
colMapDeptNme.DestinationColumn = "DEPTNAME";
colMapDeptMgr.DestinationColumn = "ADMRDEPT";
colMapDeptLoc.DestinationColumn = "LOCATION";
colMapDeptNum.SourceColumn = "DEPTNUMB";
colMapDeptNme.SourceColumn = "DEPTNAME";
colMapDeptMgr.SourceColumn = "MANAGER";
colMapDeptLoc.SourceColumn = "LOCATION";
salesCopy.ColumnMappings.Add(colMapDeptNum);
salesCopy.ColumnMappings.Add(colMapDeptNme);
salesCopy.ColumnMappings.Add(colMapDeptMgr);
salesCopy.ColumnMappings.Add(colMapDeptLoc);
try
{
salesCopy.WriteToServer(reader);
salesCopy.Close();
}
catch (DB2Exception ex)
{
MessageBox.Show(ex.ToString(), "Exception");
}
}