Re: SQL Giving different results in "Run SQL Scripts" vs in my SQLRPGLE program

[Charles Wilt <charles.wilt@xxxxxxxxx>]

In STRSQL, hit F13=Services, then take option 1. Change session attributes.

On the second page, take a look at
Sort sequence  . . . . . . . .   *JOB


On the CRTSQLRPGI command, the default is:
Sort sequence  . . . . . . . . .   *JOB

You could also specify SET OPTION SRTSEQ = *JOB in your code.

Charles

On Mon, Sep 12, 2016 at 11:34 AM, Mathias Langlet <
Mathias.Langlet@xxxxxxxxxxxxxxx> wrote:

> Hi all,
>
> The SQL
> SELECT TABLE_NAME FROM QSYS2.TABLES WHERE TABLE_SCHEMA = 'XXXOPR' AND
> TABLE_NAME like 'XXXAPIL%' order by TABLE_NAME desc limit 1;
> Returns XXXAPIL014 when running in the Run SQL Scripts interface and
> XXXAPILOGT when running in as embedded SQL in my SQLRPGLE program.
>
> Same thing with the query:
> SELECT MAX(TABLE_NAME) FROM QSYS2.TABLES WHERE TABLE_SCHEMA = 'XXXOPR' AND
> TABLE_NAME like 'XXXAPIL%';
>
> Any ideas what’s going on here?
>
> Here is the list of all tables in ICEOPR that matches the like:
> XXXAPIL014
>
> XXXAPIL013
>
> XXXAPIL012
>
> XXXAPIL011
>
> XXXAPIL010
>
> XXXAPIL009
>
> XXXAPIL008
>
> XXXAPIL007
>
> XXXAPIL006
>
> XXXAPIL005
>
> XXXAPIL004
>
> XXXAPIL003
>
> XXXAPIL002
>
> XXXAPIL001
>
> XXXAPILOGT
>
> XXXAPILOGP
>
> XXXAPILOG
>
>
>
> Thanks and Regards,
> Mathias
>
> Mathias Langlet
> Lead Systems Developer
>
> ICE International Copyright Enterprise Germany GmbH
> Sonnenburger strasse 73, DE-10437 Berlin, Germany
> Mobile: +49 1511 5609142
> E-mail: mathias.langlet@xxxxxxxxxxxxxxx<mailto:mathias.langlet@
> iceservices.com>, Web: www.iceservices.com<http://www.iceservices.eu/>
>
> Geschäftsführer: Markus Nees, Sitz der Gesellschaft: Berlin, Amtsgericht
> Berlin-Charlottenburg, HRB 162426 B
> P please consider the environment before printing this e-mail
> Disclaimer: This e-mail from ICE and any attachments enclosed hereto may
> contain information which is confidential, privileged and exempt from
> disclosure under applicable law.
>
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.