Oracle: Creating a Global Temporary Table

[Sagadon Gafringo]

Grettings,
We're currently using EA 6.5.802, and we have our database tables designed in EA.  We use the Code Engineering DDL feature to automatically generate our SQL statements to create the oracle database. It's fantastic.

My question is regarding GLOBAL TEMPORARY tables.  How would I go about designing a table to generate SQL for oracle?

It should look like this:

CREATE GLOBAL TEMPORARY TABLE gProperties (
      Name VARCHAR2(50),
      Value VARCHAR2(200)
)

If I edit the name of the table object in EA to be 'GLOBAL TEMPORARY gProperties', it does this (naturally):
CREATE TABLE GLOBAL TEMPORARY gProperties...

It's my only guess as to how to try to proceed at this point. What other things should I try?

Thanks in advance!

[«Midnight»]

My guess would be to see if a tagged value on the Table object would work. Of course it is possible that this is not supported at all, in which case you should consider a feature request to Sparx.

David