Thanks to all - this gets us going.
TomH
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Monday, June 18, 2012 11:39 AM
To: Midrange Systems Technical Discussion
Subject: Re: QMQRY and authority issue
STRQM
10. Work with Query Manager profiles
2=Change
Select allowed SQL statements . . . . Y
You'll figure it out from there...
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: "Tom Hightower" <tomh@xxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>,
Date: 06/18/2012 12:32 PM
Subject: QMQRY and authority issue
Sent by: midrange-l-bounces@xxxxxxxxxxxx
My user profile has *ALLOBJ authority. When trying to run a QMQRY job on
an
SQL with an 'update' statement in it I'm getting the following message:
QMR0050 - You do not have authority to use UPDATE.
I've not used QMQRY before, but client wants to so I'm trying to get him
going.
These are the settings for my profile in QMQRY:
Default library for QM objects . . . . LOCATION Name, *CURLIB
Default object creation authority . . *LIBCRTAUT *CHANGE, *ALL,
*USE
*EXCLUDE,
*LIBCRTAUT
Authorization list
Run query mode . . . . . . . . . . . . 1 1=Interactive
2=Batch
Display run options . . . . . . . . . Y Y=Yes, N=No
Confirmation messages in QM . . . . . Y Y=Yes, N=No
Naming convention . . . . . . . . . . *SYS *SYS, *SAA
RDB Connection method . . . . . . . . *RUW *RUW, *DUW
Default library for QM tables . . . . *NONE Name, *NONE,
*CURLIB
Query data output . . . . . . . . . . 1 1=Display,
2=Printer
3=File
Printer to use for output . . . . . . *JOB Name, *JOB
F4 for list
File to use for output . . . . . . . . *NONE Name, *NONE
F4 for list
Library . . . . . . . . . . . . . . Name, *LIBL,
*CURLIB
Job description for batch run . . . . *USRPRF Name, *USRPRF
F4 for list
Library . . . . . . . . . . . . . . Name, *LIBL,
*CURLIB
Commitment control level . . . . . . . 1 1=None, 2=Change
3=Cursor stability
4=All
5=Repeatable Read
Default query creation mode . . . . . 2 1=SQL, 2=Prompted
Show query sort sequence options . . . N Y=Yes, N=No
Default column names displayed . . . . 1 1=Column Names
2=System column
names
Thanks for any help.
TomH
midrange.com
