Re: iSeries Data Extract tools

[Joel Cochran <joelcochran@xxxxxxxxx>]

From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of RobinPinoy
> Sent: Friday, November 04, 2005 8:34 PM
> To: MIDRANGE-L@xxxxxxxxxxxx
> Subject: iSeries Data Extract tools
>
> Hi all,
>
> I have a request from a customer for a simple to use PC product for
> extracting data from 1 or many iSeries tables and mapping/selecting fields
> to a text file or other PC data format types like .csv.
>
> Cheers
> Robin
> --
>

Robin,

<vendor response>
My company has a new PC tool available that may suit your needs:
http://www.ihocquery.com

You can execute SQL selects (there's your one or many iSeries tables) and
export the results to (configurable) CSV, Tab-Delimited, or XML. You can
even use it to create "Dump Files", which are text files with complete
"CREATE TABLE" and "INSERT INTO XXX" statements representing the returned
dataset.

The tool is easy to use and inexpensive at only $89 per license. The site
includes a download for the fully functional ten-use trial. All you need to
use it are the .NET 1.1 framework (a free MS download which you may already
have) and the V5R3 .Net Managed Provider from iSeries Access (the iSeries
does NOT have to be at V5R3, just iSeries Access).
</vendor response)

HTH,

Joel Cochran
Stonewall Technologies, Inc.