I don't have access to jBASE at the moment, but the following should work. Create a new item named *MY.INDEX* in the dictionary of your file, F.BATCH, with the following format:
01 S 02 N <--Replace N with number of the multivalued Job attribute 03 04 05 06 07 08 A;NV 09 R 10 4 The A correlative is on line 08. You should now get the desired result from the JQL statement LIST F.BATCH JOB.NAME JOB.STATUS MY.INDEX -- Kevin Powick On Wednesday, 26 April 2017 21:40:39 UTC-4, Jose L wrote: > > Thanks Kevin, > Could you give me an example of how to use it? I don't fully follow the > link you passed. Also, apart from a dictionary item, can it be used with > EVAL? > > JL > > 2017-04-21 14:43 GMT-04:00 Kevin Powick <[email protected] <javascript:>>: > >> 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] <javascript:> >> To unsubscribe, send email to [email protected] <javascript:> >> 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] <javascript:>. >> 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.
