Re: Client/Server on the AS/400

[Vernon Hamberg <hambergv@xxxxxxxxxxxxxx>]

Pete

At 03:16 AM 5/26/1998 -0500, you wrote:

-snip-

>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.

This statement may be misleading. A stored procedure is 'created' with an
SQL statement. The object it refers to is _any_ AS/400 program. In other
words, stored procedures are entries in a kind of program aliasing table.

What Marc Zylka was referring to, I believe, is the new feature in v4r2,
that you can use native SQL as a programming language—no embedding in RPG
or COBOL or REXX. The resulting source is converted into C source and then
compiled. There are, apparently, extensions to SQL, like 'if' and 'do'—I've
not seen it yet but heard it discussed at Connections Conference recently.

HTH

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN  55401-2499
(612) 371-1111 x480


+---
| 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
+---