You may have a problem with leading zeroes.
Are there by any chance 2 records with 9 in Record<120,2>?
On 09/09/2011 04:08, Kevin King wrote:
What can I get you Wally? We did a CREATE.INDEX WO SHOP.CODE NO.NULLS
followed by BUILD.INDEX WO SHOP.CODE. The index seems to work fine
immediately after. If the shop code in the record changes, however, the
index does not seem to reflect the change. This is evidenced by:
DISABLE INDEX WO
SELECT WO WITH SHOP.CODE = "09"
21 items selected
CLEARSELECT
ENABLE.INDEX WO
SELECT WO WITH SHOP.CODE = "09"
19 items selected
CLEARSELECT
DISABLE.INDEX WO
SELECT WO WITH SHOP.CODE = "09"
21 items selected
What else can I get you?
On Thu, Sep 8, 2011 at 5:58 PM, Wally Terhune
<[email protected]>wrote:
Not enough information.
Wally Terhune
U2 Support Architect
Rocket Software
4600 South Ulster Street, Suite 1100 ..Denver, CO 80237 ..USA
Tel: +1.720.475.8055
Email: [email protected]
Web: www.rocketsoftware.com/u2
-----Original Message-----
From: [email protected] [mailto:
[email protected]] On Behalf Of Kevin King
Sent: Thursday, September 08, 2011 5:42 PM
To: U2 Users List
Subject: [U2] Unidata 7.1.22 Index Issue
We have a customer on Unidata 7.1.22 running the Prelude application. They
have an index on a field in a file that looks like this:
Top of "SHOP.CODE" in "DICT WO", 9 lines, 82 characters.
*--: P
001: V
002: EXTRACT(@RECORD,110,2,0)
003:
004: Shop Code
005: 2L
006: S
007:
008: SHOP.CODEýýEXTRACT(@RECORD,110,2,0)
009: WO
Bottom.
Because this field is extracting from @RECORD, we should be able to index
it
without problems, right? However, the reality is starkly different. The
other data indexes work fine, but this derived index does not seem to be
getting updated properly.
-Kevin
http://www.PrecisOnline.com
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
