SQL scripts are provided for you to run to prepare your
additions or extensions for deployment.
About this task
In the
sql directory contained in
the
MDMSharedResources directory, there are a
number of SQL scripts:
- Rollback_DB2.sql
- Rollback_ORACLE.sql
- Rollback_ZOS.sql
- Setup_DB2.sql
- Setup_ORACLE.sql
- Setup_ZOS.sql
To deploy the configuration, run the setup script that
corresponds to your installed database.
There are two types of
scripts: a setup script and a rollback script. The Setup script will
deploy the exact configuration required for the current state of the
project.
Care must be taken when you use the rollback script, because
it will bulk undo whatever was last deployed, but is less targeted
than the setup.
If you are in doubt, review the content of the
script before applying it.
Important: If your solution
specifies multiple language codes in the
application.mdmxmi,
extra SQL files are generated for each language when you generate
the code. The format for the generated SQL files is
<projectName>_ERRORS_<languageCode>_<databaseType>.sql.
For example:
myModule_ERRORS_100_DB2.sql. You
must deploy all of these SQL files to the database. Remember that
running the SQL files in the
MDMSharedResources/sql folder
will run all SQL scripts in all projects in your workspace, while
running the SQL scripts in
<projectName>/resources/sql will
run only the scripts for that specific project. For more information,
see
Addition and extension deployment in the OSGi framework.
For
information on language and locales as well as language IDs, see Language and locale.
IBM InfoSphere Master Data Management, Version 11.3