× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Thanks, Nathan, for your replies - yes - we are closer than I thought - niceties of language that make little difference, I'd say now.

Your question below, copied here -

For me, SQL is the technology used to carry out the IO requests made in the RPG program.
I'm not sure if you worded that the way you intended. You're not saying
that SQL is the technology that carries out RLA requests, right?
That's right - I'm in my handler, SQL is the technology I use to carry out the RLA requests that are diverted to a handler.

Cheers
Vern


On 7/29/2016 8:29 PM, Nathan Andelin wrote:
Sometimes, Nathan, sometimes it seems you don't really get what OAR is
about - I suppose you might call it an interface - depends on what you mean
by that term.

I call it an interface because the handler has a name, keyword parameters,
and a parameter data-structure is passed each time the handler is called by
an I/O operation; similar to procedure interfaces.

The parameters the handler will receive are defined by OAR - I suppose that
would be the interface.

Yes.

The OAR whatever and handler don't solve anything on their own. One of the
things you receive in the main handler parameter is which operation was
requested - and you write code to process that as desired. The CODE in the
handler is what solves the problem, not OAR itself.

Yes, I agree with that. You're also admitting that the handler may solve a
problem, say a problem with field-proc encryption which a programmer who
may be using RLA opcodes may know nothing about, which IBM's default DB I/O
procedures may not be designed to handle.

I'm probably missing the point somewhere. You mention something you call
SQL IO - I'm not sure what that means, either.

I say SQL I/O when referring to SQL SELECT, INSERT, UPDATE, DELETE, etc.
SQL Statements which cause the SQL Query Engine to call DB I/O procedures
under the covers (which are listed in the JOB's call stack).

For me, SQL is the technology used to carry out the IO requests made in the
RPG program.

I'm not sure if you worded that the way you intended. You're not saying
that SQL is the technology that carries out RLA requests, right?

I think of SQL as language statements and elements. The runtime engine
(SQE) makes decisions about how to process statements, perform DB I/O, and
return results.

I think I understand RPG open-access much better than you give me credit,
including a good understanding of the mainstream OA handlers which are used
to supplement display files.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.