DB2 V9.7 for Linux, UNIX, and Windows
DB2 V9.7 for Linux, UNIX, and Windows
要从数据源中复制的列的序号值。
[Visual Basic]
Public Property SourceOrdinal As Integer
[C#]
public int SourceOrdinal {get; set;}
[C++]
public: __property int get_SourceOrdinal();
public: __property void set_SourceOrdinal(int);
[JScript]
public function get SourceOrdinal() : int;
public function set SourceOrdinal(int);表示源列的序号的整数值。
如果多次设置了源列值（例如，将值多次添加至 SourceColumn 或 SourceOrdinal 属性，或者对这两个属性中的每个属性至少指定了某个值一次），那么将在 Add 方法中使用最后设置的值。
[C#] 以下示例演示如何将 DB2DataReader 中的数据成批复制到 DEPARTMENT 表中。源表和目标表之间的列映射由 SourceOrdinal 和 DestinationOrdinal 属性在 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.DestinationOrdinal = 0;
colMapDeptNme.DestinationOrdinal = 1;
colMapDeptMgr.DestinationOrdinal = 3;
colMapDeptLoc.DestinationOrdinal = 4;
colMapDeptNum.SourceOrdinal = 0;
colMapDeptNme.SourceOrdinal = 1;
colMapDeptMgr.SourceOrdinal = 2;
colMapDeptLoc.SourceOrdinal = 4;
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");
}
}