×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
