However, if the position of a datum in a multivalue is important, then the data design is completely broken.
Jim > On Apr 21, 2017, at 19:43, Kevin Powick <[email protected]> wrote: > > Look into creating a dictionary item with the A Correlative using the NV > System Parameter Operand. > > http://jbase.com/r5/knowledgebase/manuals/3.0/30manpages/man/jql2_CONVERSION.A.htm > > -- > Kevin Powick > >> On Friday, April 21, 2017 at 12:26:00 PM UTC-4, Jose L wrote: >> Hello, >> I have a table with some fields multivalued. I can list them and I got a >> list for each one of the multivalues: >> >> LIST F.BATCH JOB.NAME JOB.STATUS >> >> PAGE 1 11:36:05 21 APR 2017 >> >> >> >> @ID............................................... >> JOB.NAME........................ JOB.STATUS >> >> BNK/REGEN.CRF.RVL.PRT EOD.CRF.REVAL 0 >> >> EOD.CRF.REVAL.POST >> 0 >> RE.UPDT.STAT.LINE.CONT >> 0 >> EB.STAT.PRINT >> 0 >> BNK/SC.BATCH.PERF SC.EOD.CASH.FLOW.TRANS 0 >> EOD.CFT.MKT.UPD >> 0 >> >> SC.PERF.DETAIL.UPD.BATCH 0 >> EB.PRINT >> 0 >> BNK/SC.SAFE.FEES.POST SC.SAFE.FEES.CREATE 0 >> SC.SAFEKEEP.ACC.REPORT >> 0 >> >> >> >> I would like to get a colum with the index of the multivalue, so it would >> apper as follows: >> >> LIST F.BATCH JOB.NAME JOB.STATUS >> >> PAGE 1 11:36:05 21 APR 2017 >> >> >> >> @ID............................................... >> JOB.NAME........................ JOB.STATUS MY.INDEX >> >> >> BNK/REGEN.CRF.RVL.PRT EOD.CRF.REVAL 0 >> 1 >> EOD.CRF.REVAL.POST >> 0 2 >> RE.UPDT.STAT.LINE.CONT >> 0 3 >> EB.STAT.PRINT >> 0 4 >> BNK/SC.BATCH.PERF SC.EOD.CASH.FLOW.TRANS 0 >> 1 >> EOD.CFT.MKT.UPD >> 0 2 >> >> SC.PERF.DETAIL.UPD.BATCH 0 3 >> EB.PRINT >> 0 4 >> BNK/SC.SAFE.FEES.POST SC.SAFE.FEES.CREATE 0 >> 1 >> SC.SAFEKEEP.ACC.REPORT >> 0 2 >> >> >> Is there any way to do that? >> >> Thanks >> >> JL > > -- > -- > 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. -- -- 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.
