Re: create procedure giving Not authorized to CREATE PROCEDURE -- MIDRANGE-L

Subject: Re: create procedure giving Not authorized to CREATE PROCEDURE
From: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
Date: Sat, 28 Jul 2012 16:04:52 -0500
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>
X_cmae_category: 0,0 Undefined,Undefined

Tim

What are the messages that come before the error message? There's often more information there, and we can only guess until we know more.

What interface are you using? If STRSQL, put cursor on message and press F1, then F10.

If Navigator, WRKOBJLCK YOURUSERID *USRPRF and see if there's a QZDASOINIT job for you - then check it's job log.

Thanks
Vern

On 7/28/2012 12:53 PM, tim.dclinc@xxxxxxxxx wrote:

im trying to create a procedure and get Not authorized to CREATE
PROCEDURE. message. I checked the authority of SYSROUTINES in QSYS2 and
qpgmr has full authority which my profile is part of.

What else am i missing?

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: create procedure giving Not authorized to CREATE PROCEDURE , tim.dclinc@xxxxxxxxx

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.