The latest version of IBMi Access released today (Dec 9 2015) now allows you to run SQL scripts! It also has an improved UI with color coded SQL!
You can download the latest IBM i Access Client Solutions here: https://t.co/jInoj0OtDX
Big thanks to Jesse Gorzinski’s team and everyone at IBM that made this possible! We finally aren’t married to the Windows iSeries Navigator for running SQL! We can now use this tool on Mac, Linux or Windows!
Not to be a Debbie Downer, but with all the options for running SQL Queries through JDBC based SQL clients, why adopt this? It seems like a good thing for people that stick to just the client tools, and it might grow to offer some compelling features, but it doesn’t seem as good as SqlWorkbench.
Are there some compelling features that I miss? For example if a stored procedure writes to a spool file or the job log, will this tool alert me to that fact? Can I step through a stored procedure?
Sure there is other tools out there, but they aim to please everyone, while this tool is aimed to please IBM i developers only. I do believe there are some things only this tool will do. I was only able to get “Dynamic Compound statement” to work on the iSeries Navigator “Run SQL” interface.
There are a plethora of other features in ACS. Such as Job Log,Job Details,SQL Details,System debugger (I think this could be used for debugging you Stored procedures). There’s also SQL Performance Center – Analyze, show statements, compare, sql plan cache, and eventually Visual Explain.
Wondering what a Dynamic Compound statement is? – http://www.itjungle.com/fhg/fhg011514-story02.html