Re: Client/Server on the AS/400

[Pete Hall <peteh@xxxxxxxxxx>]

At 02:59 PM 5/25/98 -0400, Marc Zylka wrote:
>Visual Basic and PowerBuilder have been mentioned.  Do these work well with
>the AS/400?  What is the best data communication software to handle data
>manipulation?  
>
>I have also read, on this list, that in order to create stored procedures
>using SQL
>that the C compiler is required, which we don't have.  Is using RPG for
>this
>a relative simple task?

Marc,

I can't comment on ProGen, but I have used both VB and PB to access data on the 
AS/400. The limiting factor is ODBC, which is now much quicker than it was a 
year or so ago, so you may be OK (I hope so, cause that's what I'm using). 
Stored procedures on the AS/400 can (must) be created with SQL, but you don't 
necessarily even need to have SQL installed. You could execute CREATE PROCEDURE 
as a query management query (part of base OS) if nothing else. You do not need 
C for this. To use QMQRY, just put the SQL in a source member and create the 
query with the CRTQMQRY command. Execute it with RUNQMQRY. If you do have SQL, 
just STRSQL and let 'er rip.

Pete


Pete Hall
peteh@inwave.com 
http://www.inwave.com/~peteh/

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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
+---