Re: Error handling in RPG IV. (and SQL v. RPG db access)

[DAsmussen@xxxxxxx]

Tim,

In a message dated 97-07-04 08:26:55 EDT, you write:

>   I'm currently doing some (further) investigation into using
>    referential integrity and triggering on our files. (Stop! Don't
>    flame me, I know they're different things!) I've established that
>    using an embedded SQL to update a file is actually quite manageable
>    - if the INSERT breaks an R/I constraint, you just get a negative
>    return flag.

Flames are "absolutely prohibited" on MIDRANGE-L!

>    What I'm interested in, first of all, is how I might use the *PSSR
>    error handling routine to prevent a termination level error trashing
>    my program if I break a constraint. When the routine is called, how
>    do I get it to return to the point just after it was called if I
>    deem the error to be 'handleable'?

I'd be interested on an update on this as well.  We attempted to use it some
time ago, but received only cryptic "RI failed" messages (no file, no key, no
nothing).  We scrapped RI due to the fact that it was unusable in our
environment with those messages.  Has it gotten better?

>    Also, a colleague told me of anecdotal evidence that embedded SQL is
>    cool for fiddling around with large blocks of records, but gets
>    blown out of the water (performance wise) by RPG when doing record
>    by record work. Anybody else have this experience?

Oh YEAH!  Ask ANYONE from SSA!  Seems that single-record FETCH's can be an
improvement on UNIX boxes -- not so on the AS/400.  Use SQL for varied search
parameters against files with less than 200K records (on a CISC box, RISC
should support more).  Record-level stuff is still better off with a CHAIN.

Thanks!

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@AOL.COM

"Where there is an open mind, there will always be a frontier." -- Charles F.
Kettering
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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 MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *