Hi Steven, I've never used ERWIN, and we actually generate our schema through our application which calls the schema API that VSG does, so I'm a little sketchy on the exact details as they happen through VSG.... hopefully you'll get a better answer back from the rest of the group.
But...I think when you create the schema through VSG, you're telling the schema API what fields to include in the 'new' SQL table dictionary. Those fields you've chosen to include are placed in a new dictionary with the given table name (let's say you have a file called CUSTMASTER in UniData, and you include F1 - F10 in a SQL table called CUSTOMER). This actually creates a new VOC entry called CUSTOMER, pointing to the original data file CUSTMASTER, and the new dictionary D_CUSTOMER. You then create the view on this table, which you report off of. I believe it's when you create the view(s) that you create the SQLColumns table (happens automatically through VSG), which is probably where ERWIN is looking for it's metadata. (verify that w/ the consultant?) It's either that, or the dictionary items of the tables that come up in SQLTables. (However, if that's the case, it's probably a function of the UniData ODBC driver, so ERWIN shouldn't have to do anything different from the front end then MSAccess is doing.) The other thing I'd check...if you created the schema logged into the database as yourself, then you'd have to grant privilege on any views that you want the consultant to have access to (unless he's logging in as the same user you created the schema as). You do that thru VSG as well. This is SQL privilege, not your unix permissions... HTH, Amy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Frost Sent: Tuesday, November 23, 2004 11:24 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Unidata Odbc Hi -- has anybody used a tool called ERWIN against unidata ( using ODBC). This is a database modelling-reverse engineering tool one of our consultants is using to gain a graphical look at our schema. The tool doesn't appear to be showing column names for the tables/views , although MS access can see the column names. Any thoughts? Thanks -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Frost Sent: Monday, November 22, 2004 1:39 PM To: U2 Users (E-mail) Subject: [U2] Unidata Odbc Hi -- I am attempting to set up an ODBC connection to Unidta 5.2.2 I have figured that I need to edit the ud_database file in /usr/ud52/include before the ODBC connection I am using MS access -- Get External Data - Import and using the demo database However , I get a blank dialog box named "Import Objects" -- shouldn't I see a list of files from the VOC? Thanks ######################################################################## ############# This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ######################################################################## ############# ************************************************************************ **************************************************** CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. ************************************************************************ **************************************************** ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ######################################################################## ############# This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ######################################################################## ############# ************************************************************************ **************************************************** CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. ************************************************************************ **************************************************** ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
