RE: iSeries Data Extract tools

This approach always bothers me (SQL up to the iSeries from a PC
application) because you've got the security vulnerability of having the
iSeries User ID and Password cached on the PC.  Or else you have to prompt
the user for a User ID and Password each time they want to do a data
transfer, which is also a pain. Not to mention that you need to be an
iSeries customer that has ordered/installed Client Access. And I can think
of several shops off the top of my head that do not use Client Access and
will not have anything to do with it.

Just my two cents.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
Sent: Saturday, November 05, 2005 8:23 AM
To: Midrange Systems Technical Discussion
Subject: Re: iSeries Data Extract tools

<blatant vendor response>
We have a simple product that does this, called DataTransfer/400. 
There is a library on the iSeries and clients that speak to it. 
Downloads can go to CSV, Excel, dBase, MS Access, and delimited. 
Transfer setup can be saved and run from the saved file. It sends an 
SQL statement up to the iSeries. Once set up, no need to know SQL. 
Product downloadable from www.rjssoftware.com for evaluation - you'll 
need to contact us for download password and license key on iSeries. 
Unlimited clients, AFAIK. I don't have the price here at home. 
952.898.3038 during business hours.
</blatant vendor response>

There's always Excel and the iSeries Access download add-ins. They 
are a licensed part of Access, of course. That's a per/client license 
at c. $300 per.

Vern

You might look at Surveyor from www.linomasoftware.com - it used to 
be free for single user, but corporate use would cost something.
At 08:33 PM 11/4/2005, you wrote:

>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
>--
>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.