RE: CRTSQLRPGI USRPRF(*OWNER) not working

Maybe this would work better:
     C/EXEC SQL
     C+ Set Option
     C+     DynUsrPrf = *Owner
     C/END-EXEC

This way you won't have to remember a compile option.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Guy Henza" <guyhenza@xxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
09/08/2004 02:52 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
rpg400-l@xxxxxxxxxxxx
cc

Fax to

Subject
RE: CRTSQLRPGI USRPRF(*OWNER) not working






CRTSQLRPGI DYNUSR(*OWNER)
Keyword DYNUSR not valid for this command.
V5R2M0

Stave, what version are you on?

Guy

>date: Wed, 08 Sep 2004 13:53:40 -0400
>from: "Steve Peel" <Steve.Peel@xxxxxxxxxx>
>subject: RE: CRTSQLRPGI USRPRF(*OWNER) not working
>
>Check the DYNUSR parameter on the CRTSQLRPGI command,  this determines
>who's authority to use for SQL, not the USRPRF user.  Found this myself
>the hard way - the program would work fine in testing but failed in
>production when executed by 'Normal' users.
>
>Steve Peel

_________________________________________________________________
Is your PC infected? Get a FREE online computer virus scan from McAfee® 
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

--
This is the RPG programming on the AS400 / 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.