Using HSSF POI to open file in QNTC

Hi Everyone,

I'm using Scott Klement's HSSFR4 service program to open a spreadsheet in a folder on a Windows box to which my userid/pswd has authority (i.e. I can open it via WRKLNK option 5), yet when my RPGLE program tries to open it with the HSSF_Open procedure, it fails with:

RNX0301
Message . . . . : Java exception received when calling Java method.
Cause . . . . . : RPG procedure HSSF_OPEN in program UTLIB/HSSFR4 received
Java exception "java.io.FileNotFoundException: Permission denied.
/J/Accounting/FRG/ICG/Product Master Maint Template.xls" when calling method
"<init>" with signature "(Ljava.lang.String;)V" in class
"java.io.FileInputStream".

Note that "/J" is a symbolic link to "/QNTC/MyServer/MyFolder" (names change blah blah). This does not appear to be a factor. If I move the spreadsheet to another directory within "/J" to which *PUBLIC has *RW authority, it opens just fine.

My theory is that the class "java.io.FileInputStream" is actually running in a batch interactive job spawned from my job, and that batch interactive job is running under QUSER or some other userid that does not have authority to the "/J/Accounting" folder.

My questions are 1) is my theory correct? 2) how can I see what user the batch interactive job is actually using? and 3) is there a way to have the batch interactive job use my userid/pswd?

tia,
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /