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

[CRPence <CRPbottle@xxxxxxxxx>]

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