RE: SQLRPGLE - Authority Problem.

["Andrew Lutz" <andrew.lutz@xxxxxxxxxxxx>]

Chris,

I have the environment you describe.

Besides the usual RPG compile parameters, embed this in your code.

*                                              
 C/Exec SQL                                      
 C+                  Set Option                  
 C+                      Commit    = *CHG,       
 C+                      DatFmt    = *ISO,       
 C+                      TimFmt    = *ISO,       
 C+                      UsrPrf    = *OWNER,     
 C+                      DynUsrPrf = *OWNER      
 C/End-Exec                                      
*                                              



-----Original Message-----
From: Chris Beck [mailto:CBeck@xxxxxxxxxxxx] 
Sent: Monday, June 16, 2003 9:07 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: SQLRPGLE - Authority Problem.

I have a SQLRPGLE program that uses a cursor.  The file that the cursor
select is on has public *EXCLUDE, but we use Adopted authority.  The
program will not work unless I have *allobj, or specific rights to the
file. I checked the adopted authority settings, and they are working for
everything else.  Why does the program not use the Adopted authority?



Thanks 

Chris 



_______________________________________________
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.