RE: Getting a file to excel

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Yes, we have a default user for our file transfer utility that uses QNTC, but 
in this case, mapping to end-user folder destinations would need to be defined 
for hundreds of users.  We're concerned that each user's output should be 
secured from access by all other users, requiring a unique destination for each 
user.  We *could* go this way, but network support group does not want to 
manage this....  

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Scott Johnson
Sent: Friday, June 30, 2006 4:03 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Getting a file to excel


What I did here to get around user access issues is create a userid that 
exists on both the AS400 side and the PC server side.  On the AS400, the 
job that creates the spreadsheet is run using this userid.  It writes the 
spreadsheet to a folder on a pc server using the QNTC in the IFS.  I just 
have to tell the network admin that this user needs access to that folder.

-- Scott J.

DeLong, Eric wrote:
> One of the problems we have with that is that not all iSeries users keep
their Windows and iSeries profiles in sync. SSO is not an option, and I was
told NO to creating a web app to serve as a file/report broker. I could
solve this easily if I had some way to force a "login as user...." dialog
whenever the user tried to access the IFS, but I can't see any way to do
this.....
> Eric DeLong
> Sally Beauty Company
> MIS-Project Manager (BSG)
> 940-297-2863 or ext. 1863