Database Generation

After defining the metadata, the data model can be generated with the next statements:

begin

 --

 -- Aanmelden op Invantive Producer.

 --

 itgen_session.set_session_info

 ( '<applicatie code> installatie.sql'

 , 'install'

 , 'system'

 , 'various'

 , sys_Filter('userenv', 'ip_address')

 , sys_Filter('userenv', 'host')

 , 'n/a'

 , to_char(sysdate,'yyyymmddhh24miss')

 );

 --

 -- Aanmaken van:

 -- * tabellen

 -- * indexen

 -- * referentiele constraints

 --

 <applicatie code>_install.sync_db_with_metadata;

end;

/

These statements ensure that the physical data model will be similar to the data model in the repository. New columns get - if a conversion function is known - automatically a new value.