Allen:
Thanks. Yes I did. The results were in the original email. But here they are
again.
22 Demo (0)-> LIST.INDEX GLPOST
Alternate Key Index Details for File GLPOST Page 1
File.................. GLPOST
Alternate key length.. 45
Node/Block size....... 4K
OV blocks............. 1 (0 in use, 0 overflowed)
Indices............... 2 (0 D-type)
Index updates......... Enabled, No updates pending
Index-Name...... F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr....
INDEX_1 V Txt Yes Yes Yes Yes S YRMO_PSTD : JRNL
INDEX_2 V Txt Yes Yes Yes Yes S OCONV( CLIENTNO,
'MR%4' ) : YRMO
_PSTD : OCONV( A
CCTNO, 'MR%6' )
: OCONV( @ID, 'M
R%8' )
Bill
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of Allen
>E. Elwood
>Sent: Wednesday, August 15, 2007 2:23 PM
>To: u2-users@listserver.u2ug.org
>Subject: RE: [U2] UD: Using indexes in UniQuery
>
>Did you try LIST.INDEX GLPOST ?
>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett
>Sent: Wednesday, August 15, 2007 13:33
>To: u2-users@listserver.u2ug.org
>Subject: RE: [U2] UD: Using indexes in UniQuery
>
>
>Martin:
>
>This is not the case. The dictionary looks like:
>
>2 Demo (0)-> .X
>AE DICT GLPOST INDEX_2
>Top of "INDEX_2" in "DICT GLPOST", 9 lines, 364 characters.
>*--: P
>001: I This is the INDEX dictionary that determines what the
>index is for
>this file.
>DO NOT add anything else to the 'correlative' field!!!
>002: OCONV( CLIENTNO, 'MR%4' ) : YRMO_PSTD : OCONV( ACCTNO, 'MR%6' ) :
>OCONV( @ID,
>'MR%8' )
>003:
>004:
>005: 24L
>006: S
>007:
>
>...and the output looks like the initial email.
>
>2 Demo (0)-> list GLPOST WITH INDEX_2 LIKE "0605..." INDEX_2
>list GLPOST WITH INDEX_2 LIKE "0605..." INDEX_2 13:32:07 Aug 15 2007 1
>GLPOST INDEX_2.................
>
>583056 060520030800307000583056
>726857 060520040100500000726857
>583057 060520030800500000583057
>726858 060520040100400000726858
>583058 060520030800306000583058
>.
>
>This suggests the index isn't used at all, as the output
>should be sorted
>properly.
>Hope this helps.
>
>Bill
>
>>-----Original Message-----
>>From: [EMAIL PROTECTED]
>>[mailto:[EMAIL PROTECTED] On Behalf Of
>>Martin Phillips
>>Sent: Wednesday, August 15, 2007 1:11 PM
>>To: u2-users@listserver.u2ug.org
>>Subject: Re: [U2] UD: Using indexes in UniQuery
>>
>>Hi Bill,
>>
>>The index system should be able to handle a trailing
>wildcard. My immediate
>>thoughts are that the relevant dictionary item might be
>defined as right
>>justified which would result in a right justified sort in the
>index tree
>>which may in turn prevent use of the index for this item.
>>
>>Please check if this is the case and let me know. If it is
>the cause of
>your
>>woes, you will need to delete the index, modify the
>dictionary item and
>then
>>recreate/build the index.
>>
>>
>>Martin Phillips
>>Ladybridge Systems Ltd
>>17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
>>+44-(0)1604-709200
>-------
>u2-users mailing list
>u2-users@listserver.u2ug.org
>To unsubscribe please visit http://listserver.u2ug.org/
>-------
>u2-users mailing list
>u2-users@listserver.u2ug.org
>To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
