No order by clause. Something in the move reordered the records in the
actual file or table.
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Steve
Jones
Sent: Thursday, April 30, 2015 12:27 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: 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.
Kevin Bucknum
Senior Programmer Analyst
MEDDATA/MEDTRON
Tel: 985-893-2550
As an Amazon Associate we earn from qualifying purchases.