Michael Hill wrote: > >Can you tell me how easy it is to do the following: > > > >* Read an AS/400 file (whether it be by RPG program or SQL embedded in > >Net.Data to retrieve Product Code, Product Description, and Quantity on Hand) > >* Display it on the screen (Like an AS/400 subfile) > >* Allow them to change say Quantity on Hand > >* Update the AS/400 Database via either a program or SQL Okay. Easy. These are things to do/consider: There is a great Redbook called Unleasing AS/400 Applications on the Internet (SG24-4935-00) Two ways of doing this. One is the HTML gateway that allows the conversion of 5250 to HTML. This is not yet a great product but it works and you don't ned to use HTML, CGI, etc, etc. You see your standard Order Entry, Warehouse menu, whatever from within your browser. To get this going you need to start the WSG service with the STRTCPSVR command (STRTCPSVR *WSG). Then go into your browser and connect to http://hostname:5061/WSG. The other method is more complicated. Firstly writting HTML is a cinch. If you can program in RPG you can handle HTML. Also plenty of sites exist with similar design concepts. No shame in resuing the code. Design the screen. Use SQL to display the details you want. Simple and quick. Write CGI (Net.Data) macros that execute RPG/CL/Rexx programs that update the data once the user has changed it. Using an RPG program for the update instead of SQL just allows you that bit of extra error checking. No sense in allowing the users on the web site to directly SQL the PF. > >>Why is it a pain in the ass. Mainly CGI. I had a lot of trouble getting my head around CGI and then puzzling over passing variables to AS/400 programs. Anyway good luck and feel free to ask any other questions you like. James Turnbull AS/Tech Consulting +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to "MIDRANGE-L@midrange.com". | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: email@example.com +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.