Enumeration Reload SQL
If you want to have access to your static enumerations defined in your Xomega model
in the database layer, then you can easily generate a rerunnable SQL script that
loads enumerations' data into the corresponding database tables using this generator.
The tables should have a general dictionary structure, and you can have dedicated
tables for individual enumerations or a generic system dictionary for storing multiple
enumerations. You can also store any specific additional properties as columns on
the dictionary table or arbitrary properties as a generic child table of the dictionary
All of those tables should be represented by corresponding objects in your Xomega
model that are configured to store enumerations as appropriate. If you configure
such dictionary objects for existing database tables, then you can also import their
data as model enumerations first instead of manually defining those enumerations
and their values.
The following topics provide more details and step-by-step instructions for this
generator and the related tasks.