Re: ACS Run SQL Scripts bug?

["Kevin Adler" <kadler@xxxxxxxxxx>]

Charles, please open a PMR. We have a few known issues with the ACS SQL 
parser that will be fixed in an upcoming update and have a test fix 
available.



"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 03/17/2016 
01:26:16 PM:

> From: Charles Wilt <charles.wilt@xxxxxxxxx>
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Date: 03/17/2016 01:26 PM
> Subject: ACS Run SQL Scripts bug?
> Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
>
> 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.
>