Re: ACS Run SQL Scripts bug?

I have found it has problems with the CASE statement, to name just one
problem I've found.
I've had several problems with the ACS Run SQL Scripts program and it is
unusable for me.
I opened a PMR and have been going back and forth with IBM with no luck.
They had me try a couple of fixes with no success.
It's a real shame they released it the way it is and now taking so long to
address the issues.
I'm guessing it's a low priority for IBM.


Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (416) 675-9200 ext. 89224
Cell: (416) 317-3144


On 17 March 2016 at 14:26, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

Getting an error with the following:
select *
from vaiconvml.mvvendms ap
full outer join vaiconvml.vorvendmst iv
on ap.vvndno = case iv.vapvno
when 0 then iv.vvndno
else iv.vapvno
end;

The error is
##### Parsing error at line 7 #####

The above works fine in the green screen Run SQL Scripts and in iNav's Run
SQL Scripts.

Apparently ACS's Run SQL Scripts is trying to parse the statement before
sending it to the system.

Running:
*IBM i Access Client Solutions*
*(32-bit)*
*Version: 1.1.5.0*
*Build id: 5492*
*December 4, 2015 10:46:24 AM EST*

*java.version: 1.8.0_40*
*java.vendor: Oracle Corporation*
*java.home: C:\Program Files (x86)\Java\jre1.8.0_40*

*Think that's the latest.*
*Charles*
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.