Data Dictionary / Meta Data? How to extract?

[ItsOnlyRocketScience]

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. (there are no icons for chicks?! - its a cruel world)

[BeeJay]

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]

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]

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]

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;

[ItsOnlyRocketScience]

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.