RE: Web to AS/400 Database connectivity

["Stone, Brad V (TC)" <bvstone@xxxxxxxxxxxxxx>]

Dave,

What method do you use to access the data from the AS/400?  What CGI
language(s) are you using? I'm assuming Perl if your running Linux.

I am interested because you say you don't like DataGate because it's an
extra layer.  Well, is there not a "layer" in your current config?  Just
curious.  I've only used ASNA to test their VRPG product, and found DataGate
very stable and fast.  I've also used data "mirroring" products which I've
found less stable and in some cases can't do what we want them to do without
a lot of setup and programming.

Brad 

> Although the Asna product works well, I don't like it because 
> you have to
> run
> Datagate to access the as/400 database.  If the datagate 
> subsystem is down
> your
> data won't be served.  It also adds another layer between the 
> application
> and DB/2.
> 
> It does make development a little easier but a properly 
> designed server
> application
> could do the same work without another software product in the middle.
> 
> We serve our web pages from a set or redundant linux servers 
> with custom CGI
> programs
>  accessing the as/400 for the data we need.  We chose this 
> method because it
> was the most efficient way to apply the complex 
> databaserelationships (our
> business rules).
> 
> We chose to use db contraints and triggers for database 
> integrity which put
> a great deal of the business rules right into the database itself.
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: 
> david@midrange.com
> +---
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---