I've been a system tester on one project that connected a DB2 database running on an AS400 (I think that's right) with a web front-end by using IBM's DB2Connect to access the database through Java Beans.
As far as will PHP, ASP, XML, SQL work in doing this, well that sort of depends. Any server-side programming language will work if you have a way to access the database with it; if you have a driver that can bridge to the db on the AS400 and perhaps emulate ODBC or something standard like that, then you're golden. I'd be surprised if you found anything out-of-the-box that worked for PHP or ASP. As far as XML goes, it might be useful in doing something like modelling data retrieved from the db on the AS400 and transmitting it to the Unix box, then using XSL or CSS to convert it to HTML. SQL will only help if the database on the AS400 can be queried using SQL.
All of this assumes you're looking to do real time queries and updates; I think in the past batch processes have been a common solution. You update the client/server database with data from the AS400 once a day, and at the end of each day you update the AS400 database with all the transactions that happened on the client/server system.
Again, my only advice is to look to the vendor of your legacy database and see if they don't have a product like DB2Connect for DB2 that bridges the gap between legacy and client/server for you.
Good luck.
Jay Eckles
www.jayeckles.com