Hi Pat, Thanks for this. It worked as you outlined.
Rick On Thursday, September 27, 2018 at 1:31:35 PM UTC-4, Patrick Payne wrote: > > 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.
