× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. September 2013

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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.