I need some ideas here...I'm stuck.
I'm running an RPG program that builds some CSV files for our accounting department. Because they love Excel, I had to make it so that the program breaks the data up into separate CSV files so as not to exceed 65,535 rows. Anyway, I am saving the stream files into a shared folder under QOpenSys on my i5 515. When the program is done, it tries to execute a command on the PC "start explorer.exe \[ip address]Accounting$", where the accounting folder is the share on the 515.
This works if the user (currently me for testing) has tried to access any share on the 515 through Windows at least once prior, since Windows prompts for a user name and password. But, when my RPG program does this, sometimes it silently fails on the PC, only opening the MS-DOS prompt long enough to blink and then nothing. Other times we clicked around and tried typing in the UNC path the the 515 and it finally asked us for a username and password.
I wanted to make this easy for my users to be presented with the data as soon as it is done so they can continue to work with it. But if they have to jump through hoops I fear it will not really help them.
Currently I am using STRPCO, and STRPCCMD. I tried with RUNRMTCMD, but don't like the fact that I would have to physically 'touch' each PC to make sure the service is running and allowed to interact with their Desktops.
Is there any way for me to cause the user to be prompted for their sign on and password instead of this just blowing up silently? Any advice? Thanks!!