Re: iSeries as remote SQL server

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Rich, the standard SQL access to iSeries is via either ODBC, JDBC, or 
OLE/DB using ADO in something like Visual Basic, Visual C++, or even Excel. 
Drivers or providers for all 3 are a part of iSeries Express for Windows, 
and there is an ODBC driver for Linux - don't know about one for Unix. 
Apparently the Linux driver requires the free Unix Windows Manager for 
ODBC, available at www.unixodbc.org, so it might be possible to use it - no 
idea for sure. But apparently the iSeries Toolbox for Java JDBC driver works.

I got this information with a google on "iseries+odbc+driver+unix"

Good luck
Vern

At 01:48 PM 10/27/2003 -0600, you wrote:
> Is there a way to easily, efficiently and inexpensively access the iSeries 
> database from a remote client machine?  In my case, the remote client is 
> an intel box running unix or windows.  I'd like to be able to use both 
> types of machines as clients.
>
> Using Perl/MySQL I routinely do things like:
>
> sub _update_account {
>   my $self = shift;
>
>   $self->dbh->do( qq{ UPDATE account
>                       SET last_tran_invoiced = ?, last_invoice = ?
>                       WHERE id = ? },
>                   undef,
>                   $self->inv->{thru_sequence},
>                   $self->inv->{invoice_date},
>                   $self->inv->{accountid});
> }
>
> Sure would be nice to be able to do the same with an iSeries as the target.