Re: SQL - Limit and Offset Not Working

[Charles Wilt <charles.wilt@xxxxxxxxx>]

can you show your code?

On Mon, Mar 7, 2016 at 10:33 AM, Brian <belstsrv@xxxxxxxxx> wrote:

> Hi All,
>
> I am working on an application to pass records to a web application.  I
> located information on using LIMIT and OFFSET in SQL but then learned we
> didn't have 7.1 TR11 installed.  That was installed this weekend during
> maintenance and I believe I confirmed this by doing:
>
> DSPPTF 5770999
>
> I can then page down and see this PTF ID says it was permanently applied:
> MF99011
>
> I believe that confirms it was applied.
>
> But, when trying to use either LIMIT or OFFSET in my program, it fails on
> the PREPARE statement.  Thinking maybe I had some issue in the code, I
> tried using System i Navigator (old program, not web version) to run the
> SQL statements as I'd read you can use those options there but not in
> STRSQL.  But, when trying to use them there, I still get an invalid token
> error.
>
> I am not sure what to do next to try and troubleshoot this.
>
> Any advice would be awesome.
>
> Thanks!
> --
> 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.