Oracle Reverse key index

[eblasf]

I'm using "Generate Package DDL" function and I would like to generate a reverse key index for Oracle, like that:

CREATE INDEX IDX_EXPIRATION ON TABLE1 (EXPIRATION ASC) REVERSE;

Is this with Enterprise Architect possible?  

[qwerty]

As the DDL gen script is available you can modify it at your wish.

q.

[eblasf]

Interesting

How can I do that?
Where is this script?
Did you have a link on a tutorial or some documentation please.

[qwerty]

Tutorial? You must be kidding ;-)

Look into Settings/Model Transformation Templates. Then select DDL from the drop down. You can make a copy and experiment freely. The help will give you some hints and there are quite some posts here on the forum related to transformation.

Good luck.

q.

[eblasf]

Thank you qwerty, I appreciate your help
I'm not sure we are speaking of the same thing. You are speaking about Model Transformation (MDA).

But I'm speaking about Database Engineering/Generate Package DDL, this function write an sql script which I can use to create my database model.

[qwerty]

Stupid me. I was riding the wrong horse  

The DDL gen of course is the way it is and you can not modify it except for the options presented. But what you can do is to write your own exporter with a script. This is rather easy I'd say.

q.

[eblasf]

Thank you qwerty.

Another question again. Where can I found some exporter script sample?

[qwerty]

I don't know whether there are such script examples. There is some csv sample if you enable the EAScriptlib MDG which might help a bit.

Basically you would write a file based on a package containing <<table>> classes. You'd need to analyze attributes/connectors (columns), methods (triggers) and tagged values (special stuff).

If you're familiar with Cxx languages have a look in Geerts addin framework.

q.

[eblasf]

Good, I will try when I have more time.

Thank your for you help,