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

James H. H. Lampert wrote:
> Anybody know the MI equivalent of *START,
> as in the ILE RPG statement?:
> 
>             *START     SETLL    filename
> 
> I've just run into a dead end:
> 
> It seems that ILE RPG can take a *START on a SETLL, but doesn't 
> produce an OPM MI instruction stream, and OPM RPG can give me an
> OPM MI instruction stream, but can't take a *START on a SETLL (or
> a *LOVAL on an RRN-mode SETLL). <<SNIP>>

   I would bet that the MI instruction stream is different only for 
what would become the inputs to the program called to implement the 
two requests: RRN=1 & RRN=*START.  First verify that both result in 
an invocation of the same DB program; e.g. CALLX QDBGETDR, as shown 
in a trace.  If you can intercept the call to the one OS DB program 
for both requests, then review\compare the inputs.  I would expect 
that passing the binary inputs matching those used for the request 
to position to *START would be all that is required.?

Regards, Chuck
_______________________________________________
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.