ACS - Run SQL Scripts - Saving result data to .csv and other

Estimated reading time: 1 mins

In my last post about ACS 1.1.7.0 I mentioned that it is the first real suitable version for developers. Now I want to share another nice to know…

While IBM support tells us how to Save Result Data to .csv or .xls Files Using Run SQL Scripts in iSeries Navigator, in ACS the feature is grayed out.

Just add these two lines to AcsConfig.properties file to enable save results:

1
2
3


# Enabling Save result in Run SQL Scripts
com.ibm.iaccess.RSSSaveResultsFromUI=true
com.ibm.iaccess.RSSSaveResultsFromUIForceLoad=true</pre>

Posted on: Fri, 21 Apr 2017 21:06:58 +0200 by Markus Neuhold

Markus Neuhold

IBM i (AS/400) SysAdmin since 1997, Linux fanboy and loving open source, docker and all about tech and science.

n0r1sk - Blog