|
For me, SQL is the technology used to carry out the IO requests made in the RPG program.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.
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?
Sometimes, Nathan, sometimes it seems you don't really get what OAR isI call it an interface because the handler has a name, keyword parameters,
about - I suppose you might call it an interface - depends on what you mean
by that term.
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 wasYes, I agree with that. You're also admitting that the handler may solve a
requested - and you write code to process that as desired. The CODE in the
handler is what solves the problem, not OAR itself.
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 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.