Wj, <Sarcasm on>: Use the Don security theory, first offense, cut off a couple of fingers, second offense, cut off right hand, problem solved. <Sarcasm off> Seriously, this boils down to a management issue, employee supervision and "buy in".
Don ________________________________ From: Wjhonson <wjhon...@aol.com> To: u2-users@listserver.u2ug.org Sent: Tuesday, July 16, 2013 12:44 PM Subject: [U2] Fwd: UML mapping tool for MV (UniVerse) -----Original Message----- From: Wjhonson <wjhon...@aol.com> To: u2-users <u2-users@listserver.u2ug.org> Sent: Tue, Jul 16, 2013 9:42 am Subject: Re: [U2] UML mapping tool for MV (UniVerse) But with programmers able to create new DICT entries as they will, how do you *keep* it spotless? -----Original Message----- From: Hona, David <david.h...@cba.com.au> To: U2 Users List <u2-users@listserver.u2ug.org> Sent: Mon, Jul 15, 2013 5:40 pm Subject: Re: [U2] UML mapping tool for MV (UniVerse) Regardless of the toolset, the first hurdle would be to normalise your database to look like a relational one. Which is likely to be the greatest hurdle. Data dictionaries in U2/PICK are optional are a purely for reporting purposes - they can have duplicates and these can be conflicting. Even worse (as if you thought it could be) - data dictionaries can be incomplete or wrong. This added to the lack of enforcement of data integrity and constraints usually causes these toolsets to fail (indeed, even the UV/ODBC driver fails too!)... so good luck! Rocket released U2 Metadata Manager to assist in this respect and is designed to allow forward and backwards capability. Although, support for this in UV is limited to the latest official release... so your alternative is UV/ODBC... For UV/ODBC users - I have always recommended a separate UV account and data dictionary that is spotless. For some this is the best option - why go against the flow - when you create your own stream... _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users