Hello, The position itself of the datum is not important. We need to update the values to zero for those multivalues that are not zero. We could do it directly through a program, but for some reasons we would like to use a different approach: we want to create a list containing the ID of the record, and -separated by a comma- the position of the mulltivalue (6.1, 6.2, etc) so that we can pass that to a program that will read that list and updated the records in the table.
The purpose of this apparently convoluted way is to make the update program generic: we can pass to it any list, correctly formatted, and it will update whatever field/multivalue/subvalue we need, without having to write a specific program. What we are missing here is a simple way to get the position the position of the multivalues we need to update, again without using a specific program. JL 2017-04-21 19:51 GMT-04:00 Jim Idle <[email protected]>: > 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. > -- -- 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.
