RE: STRSQL request gives CPF4802

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

Thanks, Luis 

I didn't need your UDF in the end although I have put it in a safe place in case.

> -----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.