Uniface will create it on the fly... As in, Uniface checks if a table exists when it tries to read from it in the 1st place. If table cannot be found, and (if) you have the permissions to create objects in your database, Uniface will issue the DDL to create the table(s). Hope this helps. Regards, Knut
Hi Pedro, if you do not want uniface to create the repository on the fly as Knut already explained, but want a proper SQL setup see: https://unifaceinfo.com/forum/uniface-10-enterprise-edition/u10-3-installing-metadictionary/ what needs to be done in U10.3 to get the SQL scripts. If you want to use the metadictionary information, please note that "/ins meta" is no longer supported in u10.3; you have to perform an ordinary import of -installdi-r\uniface\misc\umeta.xml HIH, Uli
Hi Pedro, To create repository scripts in version 10 you use the new /gensql command line option with the /meta sub switch.
/gensql generates SQL scripts based on the driver options defined in the asn file so allowing greater flexibility for customers creating their repositories. In previous versions of Uniface, driver options for the meta-dictionary were limited to the ones used when generating the files for distribution.
3 Comments
Local Administrator
Uniface will create it on the fly... As in, Uniface checks if a table exists when it tries to read from it in the 1st place. If table cannot be found, and (if) you have the permissions to create objects in your database, Uniface will issue the DDL to create the table(s). Hope this helps. Regards, Knut
Author: Knut (knut.dybendahl@gmail.com)
Local Administrator
Hi Pedro, if you do not want uniface to create the repository on the fly as Knut already explained, but want a proper SQL setup see: https://unifaceinfo.com/forum/uniface-10-enterprise-edition/u10-3-installing-metadictionary/ what needs to be done in U10.3 to get the SQL scripts. If you want to use the metadictionary information, please note that "/ins meta" is no longer supported in u10.3; you have to perform an ordinary import of -installdi-r\uniface\misc\umeta.xml HIH, Uli
Author: ulrich-merkel (ulrichmerkel@web.de)
Local Administrator
Hi Pedro, To create repository scripts in version 10 you use the new /gensql command line option with the /meta sub switch.
Regards, Mike
Author: Mike Taylor (michael.taylor@uniface.com)