RE: What do I use? RE

I would love to attend a seminar. I am in Chattanooga, TN. Do you travel
down south?

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Joe Pluta
Sent: Sunday, April 15, 2007 11:30 AM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: What do I use? RE

From: tim

- When I mentioned not being "web" based, I meant browser based. But after
reading some of the responses, I guess browser based would be ok. Now it's
a matter of what IDE to use. I do have WDSC, but it's a matter of learning
the beast.

There are lots of good references out there. Where are you located? I do
seminars on WDSC at user groups all of the time.

- Processing speed. We have a 520 and would need a solution that would
use
"batch" rather then the "interactive" portion of the processing power.
When
using VB and SQL, it hogged up the precious "interactive" resourses
bringing
the system to its knees. I believe WDSC pulls its resources from "batch".
I'm not sure about VARPG. The job running to retrieve the data was a
pre-start job and seems to run rather fast.

Actually, ODBC requests such as those made by VB run in batch. It sounds to
me like you just had some bad ODBC requests. That's one of the problems
with going that route; you need to review your application and tune your SQL
requests. Typically this involves analyzing all of your SQL requests with
some sort of analysis tool and then creating some extra indexes. If I
remember correctly, if you just run a request in SQL in debug mode (STRDBG),
the system will give you lots of good information. iSeries Navigator has
some good tools as well.

- I've read suggestions that used a graphical fronted with RPG on the
backend doing all the IO and such. Where can I find example of this
technique. Aaron Bartell had mentioned passing XML documents. Is there any
example of that anywhere?

With a browser-based approach, you need a very thin layer of Java that talks
directly to an RPG back end using program calls or data queues. For thick
clients, you would have to use your own protocol (an XML approach might
work, but I'm not sure what exactly Aaron is suggesting).

My applogies if this thread has wavered from RPG. I would like to use and
RPG'sh solution since that's where most of my experience is, but I don't
mind biting the bullet either if the general consensis might be in another
direction (JAVA, CGI, etc..)

Ask three people you'll get four answers. I am very confident in a Java/JSP
front end for an RPG back end. I have several clients running this type of
architecture for hundreds of users. Others will tell your RPG-CGI, while
still others will suggest PHP. What we REALLY need is a small online
library of several sample applications so that people can compare and
contrast the various styles.

Joe