Re: SQL: SET OPTION DYNUSRPRF

Rob,
I investigated this a while back, and the answer seemed to be, you need to recompile from source, because the SQL precompiler does something, so the generated code may be slightly different.
Hope that helps,
Mark S. Waterbury

On Tuesday, July 14, 2020, 2:38:53 PM EDT, Rob Berendt <rob@xxxxxxxxx> wrote:

Apparently the answer is yes, I do need to use the SET OPTION DYNUSRPRF=*OWNER.

So far in my testing I've found that
    ctl-opt usrprf(*owner);
is interchangeable with
    exec sql set option usrprf=*owner;
I can use one or the other.

What gets to be the issue is if there is any dynamic SQL such as EXECUTE or PREPARE like this:
    exec sql prepare STMT1 from :SQLSTMT;
    exec sql execute STMT1;
Then I need the
    Exec sql set option dynusrprf=*owner;
also.

Now I'm trying to find out if there's a way to do this after the fact without modifying source or a complete recompile.  For example, if I didn't use either
    ctl-opt usrprf(*owner);
or
    exec sql set option usrprf=*owner;
I can simply run CHGPGM PGM(...) USRPRF(*OWNER)

Is there something similar to fix DYNUSRPRF?
PRTSQLINF OBJ(ROB/SECTEST) will tell me the value of this option, but is there some way to change it without recompiling and/or source change?  Like CHGSQLINF?

Rob Berendt