Hey Rick, I am wondering if it is getting confused. I like to create the index against the actual dictionary and see what jBase does automatically. In your case I made another dictionary in which attribute 8 is
a;3:"*":4 <-- This should be faster than using the N features. Then I did a create-index sched.detail <new.dictioanry.name> jBase created as such Notice: Command converted to 'CREATE-INDEX NW.ORDERS TEST.INDEX BY ICONV(0,\A;3:"*":4\)' I did a test select and it did use the index. With more complicated indexes such as this I prefer to do it off the dictionary as it makes jBase better guess that it has a index to use. On Thursday, September 27, 2018 at 10:19:36 AM UTC-4, Rick Weiser wrote: > > So, I looked at the manual and found that I can create the index by > combining the fields. This is what I used and the error that I got. What > am I missing? > > jsh SBPF ~ -->CREATE-INDEX SCHED.DETAIL SCD.CLIENT.DATE BY 3 : "*" : 4 > Multi-Value error. You have defined an index specification that > causes problems with multi-value fields. You have defined 2 multi-value > extractions and 1 single-value extractions. The rule is that you can > only have a total extraction count of 1 for multi-value index keys, > although all the > single-value extractions only count as 1. In your definition therefore > the total extraction count equates to a value of 3. Use the (M) or -m > options to define an index definition that is not multi-value. > C:\Accounts\SBPFDATA\SCHED.DETAIL: Invalid argument > > On Wednesday, September 26, 2018 at 5:54:52 PM UTC-4, Rick Weiser wrote: >> >> Hi guys, >> >> I tried looking this up on the knowledgebase but nothing came up for >> CREATE-INDEX. >> >> I need to create an index on a correlative that looks like the following: >> >> 001 S >> 002 0 >> 003 >> 004 >> 005 >> 006 >> 007 >> 008 A;N(SCD.CLIENT) : "*" : N(SCD.DATE) >> 009 L >> 010 10 >> >> Client is attr<3> and Date is attr<4> of the same file. >> >> What would my create-index look like? >> >> Thanks, >> >> Rick >> > -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
