If it is an interactive session, then you can use the STRPCO command and run excel from the iSeries
You could configure the ‘transfer data from iSeries’ button to Excel, and let them click on that to access the data directly and cut out some of that IFS nonsense…
If the conversion is batch, then you are reliant on the user initiating the process, as there is no way of telling if they are sitting at their screen.
I’d go the STRPCO route myself.. lots of examples in places like midrange.com
Ops – should have tacked on to this
check the start up command for excel, something like
will open the file at start up