One of the features available with the V6R1 version of the IBM DB2 for i5/OS .NET Provider (version 12.0.0.0) is support for the AddBatch method on the iDB2Command object. This method is used with SQL INSERT statements and is useful when you have sets of INSERT statements. To test AddBatch, I created an SQL-defined table, using the definitions shown in Figure 1. I created a C# program (Figure 2) and Visual Basic program (Figure 3) to generate rows of data and insert them into the ...

REGISTER NOW TO ACCESS THIS ARTICLE

All registered users get access to premium content on iPro Developer for free.

Already registered? here.