• Subject: Re:
  • From: James Turnbull <jamest@xxxxxxxxxxxxxxx>
  • Date: Tue, 23 Dec 1997 14:01:41 +1100
  • Organization: International Technology Group

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: david@midrange.com
+---


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].