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

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@xxxxxxxxxxxxxxx>, 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.