Re: SQL versus READ for sequential processing

More than two...

Regards,

Guy

Inactive hide details for rob@xxxxxxxxxxxx@dekko.com

rob@xxxxxxxxx To: RPG programming on the AS400
Sent by: / iSeries
rpg400-l-bounces@xxxxxxxxxxxx <rpg400-l@xxxxxxxxxxxx>
cc:
10/13/2008 03:39 PM Subject: Re: SQL versus READ for
Please respond to RPG sequential processing
programming on the AS400 /
iSeries

I wonder how many vendors out there, who use "active record codes", or
what used to be known in RPGII and earlier as the characters used in
record identifying indicators, have indexes built using that field?
for example, if you had
Field Start End Attrib Text
IID 1 2 A2 Record ID; IM/IZ
IPROD 3 17 A15 Item Number
...
Having a index over IID and IPROD and not just a key over IPROD with
select/omits over IID?

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
This is the RPG programming on the AS400 / 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.

-------------------------------------------------------------------------------
The information contained in and transmitted with this e-mail may be
privileged, proprietary, confidential and protected from disclosure. No
privilege is hereby intended to be waived. This e-mail is intended only
for the person to whom it is addressed. If you are not the intended
recipient/addressee, any use of the e-mail and/or its contents, including,
but not limited to, dissemination, distribution or copying is strictly
prohibited and may be unlawful, and you must not take any action in
reliance on it. If you receive this e-mail in error, please immediately
notify the sender and delete the original message and any copies of it
from your computer system. We deny any liability for damages resulting
from the use of this e-mail by the unintended recipient, including the
recipient in error.