Re: Speaking of ( real ) Databases

    Hi Mike,

    I don't know your requirements, but clearly you'll have to write data
access code whether you use DB2, SQL Server or something else.  I assume you
have, um, blockage there, but wouldn't the cleanest, and probably more
secure, thing be to access the AS/400 database directly?


                                                         Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO       -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?            http://www.jguru.com/faq/Java400


----- Original Message ----- 
From: "Mike Cunningham" <MCUNNING@xxxxxxx>
To: <jshirah@xxxxxxxxxxxxx>; "Java Programming on and around the iSeries /
AS400" <java400-l@xxxxxxxxxxxx>
Sent: Tuesday, January 31, 2006 8:45 AM
Subject: Re: Speaking of ( real ) Databases


> Does anyone know if a Windows DB2 database (like this free one) can be
> synced up with an iSeries DB2 database ?  e.g. define tables that when
> changed in one DB are automatically replicated in the other DB. We have
> a bunch of processes where we FTP data down from our iSeries to a
> windows server to be served up by IIS. We also have some IIS asp apps
> that collect data on forms that we then upload to the iSeries. DB syncs
> would eliminate both these processes. If DB2 databases can be synced I
> might be able to keep SQL server out of our shop, at least for inhouse
> developed applications
>
> >>> jshirah@xxxxxxxxxxxxx 1/31/2006 8:31 AM >>>
>
>
> Update: IBM Frees DB2 Express
>
http://www.computerworld.com/databasetopics/data/software/story/0,10801,108192,00.html
>
>
>                                                          Joe Sam
>
> Joe Sam Shirah -        http://www.conceptgo.com
> conceptGO       -        Consulting/Development/Outsourcing
> Java Filter Forum:       http://www.ibm.com/developerworks/java/
> Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
> Going International?    http://www.jguru.com/faq/I18N
> Que Java400?            http://www.jguru.com/faq/Java400
>