Re: Changing USRPRF and DYNUSRPRF on SQLRPGLE

Chuck,

I was afraid of that.

And just a small correction, PRTSQLINF does show the value for the SQL SET
OPTION USRPRF...
SQLCURRULE(*DB2)
ALWBLK(*ALLREAD)
DLYPRP(*NO)
DYNUSRPRF(*USER)
USRPRF(*NAMING)

The above program has USRPRF(*OWNER) showing using DSPPGM
User profile . . . . . . . . . . . . . . . . . : *OWNER

Charles


On Sun, Jan 31, 2016 at 4:50 PM, CRPence <crpbottle@xxxxxxxxx> wrote:

On 29-Jan-2016 07:03 -0700, Charles Wilt wrote:

Is a recompile from source the only way to change the settings of
USRPRF and DYNUSRPRF?

The User Profile (USRPRF) is a Program (PGM) attribute rather than of
the SQL; the Print SQL Information (PRTSQLINF) will not even show the
USRPRF attribute, showing only the Dynamic User Profile (DYNUSRPRF)
attribute, such that the Display Program (DSPPGM) must be used instead.
Use the Change Object Owner (CHGOBJOWN) and\or the Change Program (CHGPGM)
to effect any desired modifications to the USRPRF option.

The purely-SQL OPTION attributes can be reestablished [AFaIK, *only*] by
the recompile, as effected by a new invocation of the pre-compiler with
either the updated SET OPTION or the corresponding parameter specification
on the CRTSQLxxx request; or if compiled directly from a copy of the
pre-compiled source, then the SQL_##### declaratives would need to be
updated to reflect the changed settings.

--
Regards, Chuck

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.