The SQL query is no longer executed by the CQE but by the SQE.
Optimization may be different between CQE and SQE. This can result in
different access path or even different access methods.
The following basic rule is valid for both Query Engines.
If you need your records returned in a specific sequence you have to add an
order by clause.
If the sequence does not matter, do not specify an order by clause.
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!"
-----Ursprüngliche Nachricht-----
Von: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im Auftrag von Steve
Jones
Gesendet: Thursday, 30.4 2015 19:27
An: rpg400-l@xxxxxxxxxxxx
Betreff: SQL weirdness
We moved to a new ISeries over the weekend. Old box running V5R4 - new box
running V7R1. When I do a strsql & then run the sql statement below on the
NEW BOX - I get the LAST 7 records in the file. If I run the same statement
on the OLD BOX - I get the first 7 records.
What is causing the difference?
SELECT CDTECA FROM CALNDRL0 WHERE CDTECA >= 1150430 AND CALNCA = 'MAPICS'
FETCH FIRST 7 ROWS ONLY
--
Steve Jones
H-P Products, Inc
330-871-2054
--
NOTE: The information in this email is confidential and may be legally
privileged. If you are not the intended recipient, you must not read, use or
disseminate the information; please advise the sender immediately by reply
email and delete this message and any attachments without retaining a copy.
Although this email and any attachments are believed to be free of any virus
or other defect that may affect any computer system into which it is
received and opened, it is the responsibility of the recipient to ensure
that it is virus free and no responsibility is accepted by H-P Products,
Inc. for any loss or damage arising in any way from its use.
--
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.
midrange.com
