So can't you substitute your bit of code that puts 'WITH CLIENTNO = ':MYBIGCOMMONLISTOFLITERALS into all your SELECTs and SORTs with something that puts 'WITH EVAL "SUBR(MYROUTINETHATLOCATESINCOMMONLITERALS,CLIENTNO)"' in the same place and get the same results?
HTH, Ken -----Original Message----- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Saturday, 31 January 2009 8:23 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData LIMITs Micki: Thanks for the thoughts. We do have a single subroutine that parses the list of clients/stores/departments authorized access by each user. This list, for each user, is loaded into named common. Users print/process some, most, or all information for these entities (from whatever file is of interest at the moment) all of the time. A single input subroutine is used for each report/process that asks the user what entity(s) they want to use. When the user is done selecting, this list is also held in common. All subroutines simply substitute this list into the report/process. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
