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

Wasn't exactly the same question answered yesterday in a different forum?

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)


-----Ursprüngliche Nachricht-----
Von: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im Auftrag von Mathias
Langlet
Gesendet: Monday, 12.9 2016 17:35
An: rpg400-l@xxxxxxxxxxxx
Betreff: 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.

--
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.