Shouldn't dictionary #2 Be FIELD(FIELD(@ID,'*',2),'.',3,2) Instead of FIELD(FIELD(@ID,'*',3),'.',2.2)
This will return 10000123.2 Don't know why some selects worked. Regards, Kishor Parmar -----Original Message----- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of ro...@optonline.net Sent: 04 March 2009 17:37 To: u2-users@listserver.u2ug.org Subject: [U2] Universe Index not working AIX 5.3 Universe 10.2.4 300+ user license Moved from older aix/universe 9.5 to current one in September 2008. No index problems. File contains 1.5 million records. key = company number * customer number.xx.invoicenumber.invoicesubnumber. so the key looks like 01*123456.IN.10000123.2 01*123456.IN.10000123.3 The invoice number should be unique, except for the subnumbers. dictionary #2 - FIELD(FIELD(@ID,'*',3),'.',2.2) On Monday, SELECT FILE WITH INVOICE EQ "1000123.2" found 0 records. Other SELECTS seemed to work. The keys are clean, no special characters. SELECT FILE WITH INVOICE EQ "1000123.2" NO.INDEX finds 2 records? I did a build.index file on Tuesday morning. didnt work. Late Tuesday evening, I deleted the index and recreated it and then rebuilt it. didnt work. I also copied the contents of the file and the dictionaries from one file to a new one. recreated and rebuilt the index. so no luck. There are no error messages. nothing reported when files were copied. same number records before and after. Any thoughts? Tonight I'll try a universe shutdown and restart. Thanks. Roger Glenfield ------- 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/
