Make sure the dict for PRIM.BIN.NUM is set to "R#" in the format position (<5>). Then rebuild your index. That will allow your numbers to sort as numbers and not as text strings. If you can have a combination of letters and numbers in your bin then you will have to update the dict to create a standard length for the numeric part.
Hth Colin Alfke Calgary Canada >-----Original Message----- >From: TPellitieri > >Under UniData 6.1 on AIX 5.3, I have an index on our WAREHOUSE >file for the Primary Bin Number (PRIM.BIN.NUM, V-type, >EXTRACT(@RECORD,1,1,0)). I get different results depending on >the order of selection. > >LIST.INDEX shows the following: > >File.................. WAREHOUSE >Alternate key length.. 12 >Node/Block size....... 2K >OV blocks............. 1 (1 in use, 1 overflowed) >Indices............... 3 (2 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.... >PRIM.VEND.NUM D Txt Yes No Yes Yes S 69 >VEND.NUM D Num Yes No Yes Yes M 97 >PRIM.BIN.NUM V Txt Yes No Yes Yes S ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
