AS400 and MS access

"matthew stuart" <webforumsuser@macromedia.com> wrote in message
news:gkkqp0$p0g$1@forums.macromedia.com...
>I have just been asked about a building a shopping site, but the main
>content
> of the site would be exported from an AS400 system... Is AS400 a computer
> system, or is it a database?
>
> Either way, the AS400 is where the most up-to-date info would reside, so
> therefore, is it at all possible to get an AS400 db/system and say MS
> Access to
> talk to, and update each other either automatically or manually?
>
> Eg: new products and prices in AS400 update that of the access db and new
> orders made in the access db are then added to the AS400.
>
> Is it possible, and if so, is it straight forward?

an AS400 is an old mainframe system from IBM - rebranded in 2006 as IBM
System i and replaced in 2008 by the IBM Power Systems line. IIRC, most
AS400 apps are programmed in RPG, assembly language, C, C++, Pascal, Java,
EGL , Perl, Smalltalk, COBOL, SQL, BASIC, PHP, PL/I, Python and REXX.

You'll probably want to look at http://www-03.ibm.com/systems/i/ for more
info, but I wouldn't use an Access database, unless you're talking about a
very low-traffic site. PHP/mySQL would be a better choice.

I think you need to ask IBM. The AS400 is a combination hardware and a
object oriented db software package. I believe what you want to do is
possible with a PHP/MySQL/Apache web server solution. But again, I think you
need to look to IBM for more details.


"matthew stuart" <webforumsuser@macromedia.com> wrote in message
news:gkkqp0$p0g$1@forums.macromedia.com...
>I have just been asked about a building a shopping site, but the main
>content
> of the site would be exported from an AS400 system... Is AS400 a computer
> system, or is it a database?
>
> Either way, the AS400 is where the most up-to-date info would reside, so
> therefore, is it at all possible to get an AS400 db/system and say MS
> Access to
> talk to, and update each other either automatically or manually?
>
> Eg: new products and prices in AS400 update that of the access db and new
> orders made in the access db are then added to the AS400.
>
> Is it possible, and if so, is it straight forward?
>
> Thanks
>
> Mat
>