RE: STRSQL request gives CPF4802

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Luis Rodriguez
Envoyé : jeudi 12 novembre 2009 14:13
À : Midrange Systems Technical Discussion
Objet : Re: STRSQL request gives CPF4802

David,

Not quite. A SQL Index has a different index page size. A SQL
query will try to use its own index before one defined with
DDS, as it will be more efficient.

Dan Cruikshank has a wonderful paper about modernizing
indexes and tables here:

http://www-03.ibm.com/systems/resources/systems_i_software_db2
_pdf_Performance_DDS_SQL.pdf

I highly recommend it.

BTW, just out of idle curiosity, Were you able to solve your
problem of finding the longest word in a record?

Regards,

Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries


On Thu, Nov 12, 2009 at 7:20 AM, David FOXWELL
<David.FOXWELL@xxxxxxxxx> wrote:

-----Message d'origine-----
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Dennis
Lovelady Envoyé : jeudi 12 novembre 2009 11:49 À :

'Midrange Systems

Technical Discussion'
Objet : RE: STRSQL request gives CPF4802

I'm joining 3 tables, clients, addresses and clientadresses

to get the

clients living in a town.

What determines the order of the select?
They seem to be mostly in the order of the fields in the select.

The ORDER BY clause (which is missing from your text)

determines the

order.

Ok I created a logical with key on clientName but the

request took ages and I got the message that an index was
being created with clientName during the execution. So I made
my own index and used that. The request runs instantly.

I thought the LF was equivalent to an index?
--
This is the Midrange Systems Technical Discussion

(MIDRANGE-L) mailing

list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,

please take

a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list To post a message email:
MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at
http://archive.midrange.com/midrange-l.