Re: [U2] Universe Index not working

2009-03-05 Thread Brian Leach
that the index was keyed by the ORDER NUMBER... But I haven't - Original Message - From: Charles Stevenson Date: Wednesday, March 4, 2009 4:45 pm Subject: Re: [U2] Universe Index not working To: u2-users@listserver.u2ug.org In a prior release 10.0 or earlier, I encountered a problem

Re: [U2] Universe Index not working

2009-03-05 Thread rogu2
Brian Initially testing confirms that a R versus L is the problem. thanks. Roger Original Message - From: Brian Leach Date: Thursday, March 5, 2009 5:41 am Subject: Re: [U2] Universe Index not working To: u2-users@listserver.u2ug.org Hi Over the past months we've seen a number

[U2] Universe Index not working

2009-03-04 Thread rogu2
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.1123.2

Re: [U2] Universe Index not working

2009-03-04 Thread Jeff Schasny
For starters I'd try INVOICE = FIELD(@ID,'.',3,2) ro...@optonline.net wrote: 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

RE: [U2] Universe Index not working

2009-03-04 Thread Edward Brown
@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

RE: [U2] Universe Index not working

2009-03-04 Thread kishor
...@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

Re: [U2] Universe Index not working

2009-03-04 Thread Charles Stevenson
In a prior release 10.0 or earlier, I encountered a problem that could corrupt an index if a write was issued without an explicit readu preceding it. I don't think IBM ever corrected that because writing without explicitly locking is Bad Form. If I remember, when process A holds a lock on a

Re: [U2] Universe Index not working

2009-03-04 Thread rogu2
haven't - Original Message - From: Charles Stevenson Date: Wednesday, March 4, 2009 4:45 pm Subject: Re: [U2] Universe Index not working To: u2-users@listserver.u2ug.org In a prior release 10.0 or earlier, I encountered a problem that could corrupt an index if a write was issued without