You can use an alternate dictionary in native or SQL queries... USING DICT MYALTDICT
Or more practical suggest made by Kate is to have a different dictionary definition... -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shane Ricciardi Sent: Thursday, 31 March 2011 4:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] dynamically disassociate associated fields? Hello. I have a rather large MV association that contains around 40 or so I- type dicts that all call subroutines. Since this is essentially a "subtable" to uv/SQL, selecting any field from the subtable causes all the fields to be processed, although only the requested field is returned. As you can imagine this slows things down a ton. Is there a way to tell universe to *just* process the field(s) requested in the SELECT stmt without creating new dicts & associations? Thanks. ************** IMPORTANT MESSAGE ***************************** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ************************************************************** _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users