Re: More fun with native RLA SETLL on an SQL view with a WHERE clause

"James H. H. Lampert" <jamesl-6/ELSmrcqeUu8xhjR5IN5AC/[email protected]> Mon, 03 May 2010 17:16:33 -0700
Newsgroups gmane.comp.lang.as400.mi
Message-ID <[email protected]>
CRPence wrote:

>    The pointer stored in the DMEPT has to come from the *SEPT, so 
> just update the QINSEPT before the file is opened.  I would make the 
> intercept program a CLP that does nothing more than a TFRCTL to the 
> OS DB program, in order to avoid impacting any other work that must 
> be done while debugging.  Or after the open, but before the I\O 
> request, the DM EPT could be updated in the ODP.

Hack the QINSEPT?!? On a production box?!? Uh, even if I knew how (I had 
to read the aforementioned tutorial from Leif, just to know how to dump 
it!), it's not something I'd care to risk.

Hacking the ODP would be a little more reasonable, IF I had the 
slightest idea how to do that in an ILE program.

The first recompilation only yielded a few ideas that DIDN'T work:
If I changed the option list on a .DMCGETD (RPG SETLL) to "Read First," 
the program crashed.
If I set the target RRN to zero or a negative value, the OPM RPG test 
got nothing, and the MI app got the known-excluded first record.


But I've got another recompilation cooking right now (it just finished, 
but I've been off-duty for 5 minutes already!), for tomorrow morning, 
that's got the option list for .DMCGET (RPG READ) opened up for 
manipulation in the debugger.

--
JHHL
_______________________________________________
This is the MI Programming on the AS400 / iSeries (MI400) mailing list
To post a message email: MI400-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mi400
or email: MI400-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mi400.