Data Dictionary / Meta Data? How to extract?

For questions and postings not covered by the other forums
ItsOnlyRocketScience
Posts: 3
Joined: Fri Mar 09, 2012 6:38 pm

Data Dictionary / Meta Data? How to extract?

Postby ItsOnlyRocketScience » Fri Mar 09, 2012 6:43 pm

Hi. I'm new here and brand new to Jade.

The system was implemented without a data dictionary.. wondering how I can extract one?
I have managed to run a query on the Class "class" (table? I have more experience with relational dbs)... and some text entered... how do I get table names with description and field (attribute?) names and description? Sorry, I'm not familiar with Java/Jade terminology (yet!).

Advice muchly appreciated. :geek: (there are no icons for chicks?! - its a cruel world)

User avatar
BeeJay
Posts: 312
Joined: Tue Jun 30, 2009 2:42 pm
Location: Christchurch, NZ

Re: Data Dictionary / Meta Data? How to extract?

Postby BeeJay » Fri Mar 09, 2012 8:09 pm

You make mention of Java so I wonder if you're referring to the JAva Agent Development framework instead of the JADE Development environment these boards are for:

ie: These boards are for http://www.jade.co.nz/jade/index.htm

Cheers,
BeeJay.

ItsOnlyRocketScience
Posts: 3
Joined: Fri Mar 09, 2012 6:38 pm

Re: Data Dictionary / Meta Data? How to extract?

Postby ItsOnlyRocketScience » Sat Mar 10, 2012 5:26 am

Thanks, but that link brings me back here ?? :-s

OK, perhaps delete the word "Java" from my post... as a simple user, I just want to run a query/report to extract the table names (they seem to be called classes) and description, plus field names per table and field descriptions.

Any advice please? :?

murray
Posts: 144
Joined: Fri Aug 14, 2009 6:58 pm
Location: New Plymouth, New Zealand

Re: Data Dictionary / Meta Data? How to extract?

Postby murray » Sat Mar 10, 2012 1:57 pm

For the least amount of effort you can simply extract the whole schema, which creates a ".SCM" file that will contain all the metadata for the selected schema in a structured textual format. This will be more than what you are asking for, but you can try it.

1. Go to the schema browser.
2. Select the schema you want to extract
3. Right click and select "extract"

Open the resulting ".SCM" file (ignore the.DDB file) with a text editor and have a look around ...
Murray (N.Z.)

murray
Posts: 144
Joined: Fri Aug 14, 2009 6:58 pm
Location: New Plymouth, New Zealand

Re: Data Dictionary / Meta Data? How to extract?

Postby murray » Sun Mar 11, 2012 1:01 pm

Here's a short piece of code you can run (in a workspace or JadeScript) that will list all the classes with all of their respective properties, from the current schema. This will give you an idea of how to approach the task programmatically.

Code: Select all

vars cl : Class; pr : Property; begin foreach cl in currentSchema.getAllClasses( false) do write cl.name; foreach pr in cl.allProperties do write Tab & Tab & pr.name & " : " & pr.type.name; endforeach; endforeach; end;
Murray (N.Z.)

ItsOnlyRocketScience
Posts: 3
Joined: Fri Mar 09, 2012 6:38 pm

Re: Data Dictionary / Meta Data? How to extract?

Postby ItsOnlyRocketScience » Sun Mar 11, 2012 3:09 pm

Thanks... I'll give that a go. :-)
As a regular user, I don't know if i have access to write code as you've written there. Anyway, will have a look and see. Thanks.


Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 25 guests