Don't have a good answer for this, but one hacky way would be to call a program passing the value to be accumulated which in turn maintains a named common variable. Only problem would be knowing when to reset it...
Ed -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Martin Phillips Sent: 23 July 2009 16:45 To: U2 Users List Subject: Re: [U2] FW: Running total from UniData dict Hi Kebbon, > I read this with great interest as I have an identical requirement. > However, > I use Unidata and this technique does not seem to work, in either ECLTYPE. > Does anybody have a UDT solution? >> 0001: I >> 0002: @1...@record<8> >> 0003: MD2 >> 0004: RUNNING TOT >> 0005: 10R I was quite surprised that this worked in UV. It makes an assumption that the @1 variable persists beyond the life of the I-type. It also makes an assumption that the query includes no other I-types that would overwrite this value. It has always struck me as odd that the query language doesn't have a keyword to do this much like totals, averages, etc. At risk of being told that I am shouting on the wrong list, QM does. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------------------------------------------------------------------- Please remember to recycle wherever possible. Reduce, reuse, recycle, think do you need to print this e-mail? ------------------------------------------------------------------------------------------- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee, dissemination, copying or use of this e-mail or any of its content is prohibited and may be unlawful. If you are not the intended recipient please inform the sender immediately and destroy the e-mail, any attachment(s) and any copies. All liability for viruses is excluded to the fullest extent permitted by law. It is your responsibility to scan or otherwise check this email and any attachment(s). Unless otherwise stated (i) views expressed in this message are those of the individual sender (ii) no contract may be construed by this e-mail. Emails may be monitored and you are taken to consent to this monitoring. Civica Services Limited, Company No. 02374268; Civica UK Limited, Company No. 01628868 Both companies are registered in England and Wales and each has its registered office at 2 Burston Road, Putney, London, SW15 6AR. ------------------------------------------------------------------------------------------- _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
