Wow, thanks! and caveat heeded. Vectorally (and RTFM) challenged, Stuart
-----Original Message----- From: "Stevenson, Charles" Vectoring (is 'vector' a verb?) is built into TRANS already. No need to abandon in favour of OCONVS T-correlative. You can specify a dynamic array of IDs for the target file to read. > I have used the Translate code with OCONVS() function when it > is stylistically in keeping with the use of vector functions > around it and only because there isn't a vector version of > TRANS(), but personally I wouldn't use it outside of that situation. > > custProductIDs = splice(reuse(custId),'*',productIds) instead of / as well as this: > prices = oconvs(custProductIDs,'TCUST.PRODUCT;X;;99') this works fine (even better I think): prices = TRANS( 'CUST.PRODUCT', custProductIDs, 99, 'X' ) But a caution: If CUST.PRODUCT <99> is multivalued &/or sub-valued: * T-correlative converts all delimiters to spaces when OCONVS returns. (consistent with PICK.) * TRANS will lower the returned delimiters. (almost consistent with PI.) - if called from Retrieve, the delimiters are lowered enough to keep the association with the dict equivalent of custProductIDs which might be multi-SUB-valued or even have TMs or lower. - if called from Basic, not that smart, just lowered once, so you might lose the association with custProductIDs. The above for UV. Mileage for UD may vary. cds ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ********************************************************************** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ********************************************************************** ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/