Re: [U2] dynamically disassociate associated fields?
On 01/04/11 02:36, Hona, David wrote: 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... The problem with Kate's idea is that it makes each column its own table. So you'll need masses of SQL joins if you want to be able to select a mixture of fields dynamically. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] dynamically disassociate associated fields?
Two ways Dynamic Normalization SELECT colname1,colname2,colname3 FROM tablename_assocname; Using this method only the primary key (@ID) and columns named in the association can be selected. UNNEST Operator SELECT colname1,colname2,colname3 FROM UNNEST tablename ON assocname; Using this method (which is akin to BY.EXP in the other query language TCL) you can select any columns whether from the base table (in which case they'll be repeated) or from the assocation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] dynamically disassociate associated fields?
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
[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. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users