AS400 and MS access

Report · Jan 14, 2009

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

Report · Jan 14, 2009

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
>

Report · Jan 14, 2009

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