ERP Associates, Inc.

Just yesterday one of my co-workers was using David Vandiver's Excel libraries for SQR to create a spreadsheet document from Excel, and he wanted to send the spreadsheet to the report repository.  I knew you had to write to the $PS_HOME/appserv/prcs/[DBNAME]/log_output/SQR_<sqrName>_<ProcessInstance> directory but I wasn't sure the best way to go about it.

Anyway I asked David, and he pointed me to this article that describes several options to get the directory programatically so the path name doesn't have to be changed as you migrate it from environment to environment.  The option I like is to select PRCSOUTPUTDIR from PSPRCSPARMS for your process instance, then prepend that directory to your filename before you open it.  David has written the code for this approach here .

Thanks, David!