Re: iSeries as remote SQL server

[kirkg@xxxxxxxxxxxxx]

ODBC or JBDC work well from intel platforms. Trick is finding the right 
ODBC or JBDC etc. CA/400 has one for Windows and I believe there are a 
number of other out there as well. 
_____________________
Kirk Goins CCNA
Systems Engineer, Manage Inc.
IBM Certified iSeries Solutions Expert
IBM Certified iSeries e-Business Infrastructure
IBM Certified Designing IBM e-business Solutions 
Office 503-353-1721 x106 Cell 503-577-9519
kirkg@xxxxxxxxxxxxx      www.manageinc.com




Rich Duzenbury <rduz-midrange@xxxxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/27/2003 11:48 AM
Please respond to Midrange Systems Technical Discussion
 
        To:     ISeries Mailing List <midrange-l@xxxxxxxxxxxx>
        cc: 
        Subject:        iSeries as remote SQL server


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.


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