Forums

Posted: **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.

(there are no icons for chicks?! - its a cruel world)

Posted: **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.

Posted: **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?

Posted: **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 ...

Posted: **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;

Posted: **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.

Forums

Data Dictionary / Meta Data? How to extract?

Data Dictionary / Meta Data? How to extract?

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

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

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

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

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