Re: Sequel query not working in strsql

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Yeah, if the SEQUEL product, it can have a slightly different syntax 
from IBM i SQL. Not always, but sometimes.

On 1/7/2016 11:31 AM, Richard Schoen wrote:
> SEQUEL the product or SQL ?
>
> If you're using the SEQUEL product make sure you reach out to our support team.
>
> Regards,
>
> Richard Schoen | Director of Document Management Technologies, HelpSystems
> T: + 1 952-486-6802
> RJS Software Systems | A Division of HelpSystems
> richard.schoen@xxxxxxxxxxxxxxx
> www.rjssoftware.com
> Visit me on: Twitter | LinkedIn
>
> ------------------------------
>
> message: 7
> date: Thu, 7 Jan 2016 11:59:41 -0500
> from: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
> subject: Sequel query not working in strsql
>
> I just wanted to see results of an Sequel query but this gives message
>   Token . was not valid. Valid tokens: FROM INTO.
> because when i try to run in SEQUEL it gives permissions error.
>
>
> SELECT   *.a, ohtype, ohotic, ohoush, ohiord, ohcuno, ohdeno, ohexr3
> FROM     sroorspl a, sroorshe c
> JOIN     olorno=ohorno
> WHERE    a.olsrom='100' AND a.olords=20 AND olstat=' ' AND EXISTS
>     (SELECT   *
>      FROM     qgpl/ord114 b
>      WHERE    a.olorno=b.olorno)