Page 1 of 1
How to access metadata using Universe stage
Posted: Thu Dec 14, 2006 3:36 am
by jojipjohn
Hi,
Can anyone tell me how to use Universe stage to access the metadata. I want to get the source and target tables or files and the SQL used.
Thanks & Regards
Joji John
Posted: Thu Dec 14, 2006 3:42 am
by jojipjohn
Should I Create a DSN If so how... I adding an entry to the UVODBC.CONGFIG file but I am not getting this DSN while importing the table definitions.
Posted: Thu Dec 14, 2006 7:05 am
by DSguru2B
use dsn as localuv.
Posted: Thu Dec 14, 2006 10:03 am
by jojipjohn
But if I use localuv I am getting only Example1, none of the metadata information are there
Posted: Thu Dec 14, 2006 10:27 am
by DSguru2B
Not sure about that. Never played with the repository a lot. Maybe someone else can throw some more light on it. But why do you want to do that? Its considered a hack and not supported.
Posted: Thu Dec 14, 2006 2:15 pm
by ray.wurlod
Metadata are - deliberately - incompletely described in the Repository. Further, import of the table definitions from the Repository tables is deliberately blocked. You would need to create synonyms and import the definitions from those.
You may like to review [urlhttp://
www.dsxchange.com/viewtopic.php?t=105807]this post[/url] and
this post which are both recent attempts to get at Repository data.
If you can be more precise about your requirements, we should be able to help. But no-one is going to write the whole chapter and verse about getting everything out of the Repository on this forum. This is not least because, with version 8.0, it all changes.