×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
midrange.com
