DB2Loader Constructor(String)
Initializes a new instance of the
DB2Loader class with table name that will be loaded.
The following example creates a
DB2Loader and sets some of its properties. Then prepares data and loads it into the table.
public void CreateMyLoader()
{
// Create and open connection
DB2Connection conn = new DB2Connection(
"user id=db2admin;server=db2;database=SAMPLE;");
conn.Open();
// Create loader instance
DB2Loader loader = new DB2Loader("loader_test");
// Set loader properties
loader.Connection = conn;
// Prepare for loading
loader.Open();
// Set row values
for (int i = 0; i < 10000; i++) {
loader.SetValue(0, i);
loader.SetValue(1, "test string");
loader.SetValue(2, DateTime.Now);
// Load next table row
loader.NextRow();
}
// Flush buffer and finish loading
loader.Close();
}
Public Sub CreateMyLoader()
' Create and open connection
Dim conn As DB2Connection = new DB2Connection( _
"user id=db2admin;server=db2;database=SAMPLE;")
conn.Open()
' Create loader instance
Dim loader As DB2Loader = new DB2Loader("loader_test")
' Set loader properties
loader.Connection = conn
' Prepare for loading
loader.Open()
' Set row values
Dim i As Integer
For i = 0 To 10000
loader.SetValue(0, i)
loader.SetValue(1, "test string")
loader.SetValue(2, DateTime.Now)
' Load next table row
loader.NextRow()
next
' Flush buffer and finish loading
loader.Close()
End Sub
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2