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.