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.
