BRMS function usage -- MIDRANGE-L

Jim, I ran that statement on a V7R4 system with BRMS BR2 lic pgm installed.
Ran without issue.
MM

Respectfully,
Michael Mayer
IBM i on Power System Admin
ERMCO-ECI
2225 Industrial Rd
Dyersburg, Tennessee 38024
Cell, Office and Text Messages: 518.641.8906
Email: michael.mayer@xxxxxxxxxxxxx
https://www.ermco-eci.com/
https://ermcopower.com/
IBM i Award Winning Blog Site: https://ibmireference.blogspot.com/
Awarded IBM 2024/2025 Advocate, Contributor, Influencer and IBM i Ready Badges.

3. BRMS function usage (Jim Oberholtzer)
4. Re: BRMS function usage (Rob Berendt)

----------------------------------------------------------------------

------------------------------

message: 3
date: Mon, 11 Aug 2025 10:42:16 -0500
from: Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>
subject: BRMS function usage

On a V7R5 system I run :

SELECT * FROM QUSRBRM.FUNCTIONAL_AUTHORITY_INFO ORDER BY USER_NAME, BRMS_FUNCTION_ID;

I should get output. Instead I get "[SQL0204] FUNCTIONAL_AUTHORITY_INFO in QUSRBRM type *FILE not found?

This system has reasonably recent PTF groups . What gives?.

--
Jim Oberholtzer
Agile Technology Architects

------------------------------

message: 4
date: Mon, 11 Aug 2025 12:03:54 -0400
from: Rob Berendt <robertowenberendt@xxxxxxxxx>
subject: Re: BRMS function usage

I have it on my 7.5 systems. But I'm an all BR2 shop.
Do you have ptf SI84133 as per
https://fortradocs.atlassian.net/wiki/spaces/IWT/pages/888963080/BRMS+SQL+Services
This PTF gave it to BR1.

On Mon, Aug 11, 2025 at 11:42?AM Jim Oberholtzer <
midrangel@xxxxxxxxxxxxxxxxx> wrote:

On a V7R5 system I run :

SELECT * FROM QUSRBRM.FUNCTIONAL_AUTHORITY_INFO ORDER BY USER_NAME,
BRMS_FUNCTION_ID;

I should get output. Instead I get "[SQL0204] FUNCTIONAL_AUTHORITY_INFO
in QUSRBRM type *FILE not found?

This system has reasonably recent PTF groups . What gives?.

--
Jim Oberholtzer
Agile Technology Architects

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

------------------------------

Subject: Digest Footer

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

------------------------------

End of MIDRANGE-L Digest, Vol 24, Issue 787
*******************************************