Well, I got around the problem by issuing a "CHGAUT OBJ('MyStreamFile')
OBJAUT(*ALL)" command in the CL before it tries to unlink the stream
file, and that works. Odd that I have enough authority to grant myself
authority, but not enough to remove the link in the first place.
Still, this feels kind of like a wrong approach. So if anyone (Scott ?)
knows how to set the authority correctly in the first place, I'd love to
know.
Thanks
|-----Original Message-----
|From: rpg400-l-bounces@xxxxxxxxxxxx
[
mailto:rpg400-l-bounces@xxxxxxxxxxxx]
|On Behalf Of Fleming, Greg (ED)
|Sent: Wednesday, April 11, 2007 4:24 PM
|To: RPG programming on the AS400 / iSeries
|Subject: Object/Data authority for stream files
|
|I'm using Beppe Costagliola's SQL2JXL program, which is really cool.
|
|However, it seems to have trouble removing the link for the temporary
|stream file it creates to hold the SQL statement.
|
|In his program, the following code creates the file:
|
|// Open(Create) stream file
|
| fd = open(%Addr(Filename)
|
| : S_IRWXU + S_IROTH : 819);
|
|If I understand correctly, from reading here at midrange and at Scott
|Klement's excellent tutorial, S_IRWXU (aka number 448) gives read,
|write, and execute authority to the object owner.
|
|After the program threw an error trying to remove the link, I looked at
|the authorities on the link, and my user profile appears to be the
|owner, with the aforementioned data authorities, but the *object*
|authorities are all blank for my user profile.
|
|The public authorities, both object and data, appear to be fine. They
|have read authority to the data, and ALL authority to the objects, so
|the practical upshot is that anyone except me can remove this link.
|
|What can I do to this thing to make it allow me to remove the link ?
|
|Thanks
|
|
|
|Greg Fleming
|
|Senior Programmer/Analyst
|
|Everglades Direct, Inc.
|
|
|
|--
|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.
midrange.com
