Re: getting data from the iSeries to a web page

For those of you that have analyzed what comes back - it is JSON - so YAJL
or powerEXT Core will do the job ;-)

JSON and CGIDEV2 is awkward since you need a template and there is no
correct JSON encoding of special char
and most likely no UTF-8 support.

On Wed, Dec 13, 2017 at 10:18 PM, Bradley Stone <bvstone@xxxxxxxxx> wrote:

Are you asking how to write an RPG program that reads from a DB and spits
out the information on the web page?

If so, I wrote a few books about that a few years ago... eRPG was the
title. :)

Now I'd prefer to use CGIDEV2 or eRPG SDK. But the basis is still the
same.

Your subfile program that exists now is easily converted into a CGI program
to spit that data out to a web page. I have tons of examples at:
http://erpgsdk.bvstools.com/demo/

Also, www.fieldexit.com has a ton of examples too. They do all sorts of
things from reading from a DB, to using web services to get information.

CGIDEV2 I'm sure has a lot of examples as well.


Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #16 <https://www.bvstools.com/mailtool.html>: No external
"helper" PC system required. 100% IBM i native!

On Wed, Dec 13, 2017 at 2:46 PM, Booth Martin <booth@xxxxxxxxxxxx> wrote:

Broad topic, I couldn't narrow it down because I do not understand the
issue(s) well enough. Thank you for your understanding.

OK, Lots of talk on the list about moving from green screen to GUI. I've
made some claims which, upon inspection, I can't back up. I suspect the
problem is me, not the iSeries. Hence this thread.

As a proof-of-concept I wrote a series of regular green screen programs

to

read/add/update a file of U.S. presidents and a few details of their
lives. If you are interested, the series can be seen at US Presidents <
http://www.martinvt.com/SQL_-simple-/SQL_Simple_Subfile/sql
_simple_subfile.html> ( iSeries) Its fairly simple and straight
forward, designed to be a step beyond Hello World but no farther.

Then I created a web page using the same data, with the intention of
proving I could do on an iSeries what I can do on any web server. Here

is

that web page - US Presidents <http://ventures.martinvt.com/>

So now I have both ends of the problem. Its the middle I do not have.
Currently, the version that runs on the iSeries web server has the data

in

the IFS, and I can refresh that data from a web page whenever I ask.

However I can not get the data directly from the iSeries library, which
is, to my mind, the crux of the matter.

I can provide a rundown of ways that don't work but thats boring. Hence
this post: What does work? I would like to go back as far as V5R4 if
possible but at this point I'll follow any path.

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD