That's great for plain SQL, but I doubt any of the bulk data transfer API's are available. Also, the fact that it's not built in to the RPG language makes me leery in regards to supportability? I guess you have to buy more addon products that's built into many other languages by default if you want support. Thus increasing costs.
It is just a matter of swapping out the bulk copy instantiation in my c# implementation to support any database type (syntax is the same from the one other bulk provider I looked at), therefore only one line of code has to change to support that other database type. Can you make that same adjustment in RPG?
FYI, there's also a Db2BulkCopy in .NET, however it is only available on LUW version of DB2. IBM really needs to fix their feature parity problems between the two DB2 flavors!
-----Original Message-----
From: Gary Thompson [mailto:gthompson@xxxxxxxxxxx]
Sent: Friday, September 06, 2013 12:23 PM
To: Midrange Systems Technical Discussion
Subject: RE: How to handle Big Data under IBM i?
Matt,
To support our main distribution warehouse, we currently read/write from/to MS Sql Server and DB2 on i using SQL embedded in ILE RPG.
ArdGate is an open source solution that provides the infrastructure to make MS Sql, MySql, Oracle, DB2, etc appear as a remote DB on i.
There are other, commercial solutions that support connections to remote DB for i, including DB2 MultiSystem, we happen to have chosen RDB Connect by ProData.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Matt Olson
Sent: Friday, September 06, 2013 10:29 AM
To: Midrange Systems Technical Discussion
Subject: RE: How to handle Big Data under IBM i?
Another thing, this BulkUploadToSQL utility is part of the .NET framework (built-in library), but it's specifically designed for Microsoft SQL Server. For MySQL you use MySqlBulkLoader, for oracle you use the OracleBulkCopy namespace / classes.
As you can see, these fast results are available in .NET, purely object oriented programming language and is interoperable with many database types. Whereas your DDS and RPG example is good for... DB2 on i only.
-----Original Message-----
From: Nathan Andelin [mailto:nandelin@xxxxxxxxx]
Sent: Friday, September 06, 2013 11:03 AM
To: Midrange Systems Technical Discussion
Subject: Re: How to handle Big Data under IBM i?
From: Matt Olson
Did a quick test after hours.
Thanks for taking the time to create, run, and share a benchmark program. This looks like useful information. I gather that BulkUploadToSql is a utility of MS SQL Server which is NOT available under IBM i or any other DBMS?
My test completed in 335 seconds ...
Your main program uses 2 Stopwatch components. Could you share the elapsed time for both?
-Nathan.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
