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.
As an Amazon Associate we earn from qualifying purchases.