![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
For every entity, property, or state machine whose database identifier name exceeds the database maximum length, a table name entry is created in the generated yourname.aliases file (for example, acme.aliases). See Ontology Identifiers that Exceed the DBMS Maximum Column Length for more information, and for an alternative way to specify short table names.
It is recommended that you keep the aliases file for future reference. If the project ontology changes after the backing store has data in it, you must also update the database schema to match the new schema (as explained in Updating an Existing Backing Store Schema). If you modified the generated aliases, you must use the same aliases again when you update the schema, to preserve those columns and their data.Entries in the key word mapping file are also added to the aliases file so you can replace the key word aliases with project-specific ones, as desired (generally in a second pass). For details see Task K, If Needed — Map Key (Reserved) Words to Aliases.
1.
3. Re-run the be-jdbcdeploy tool, using the same parameters as before. (For details see Task H, Generate the Project-Schema-Specific SQL Scripts (with Wizard).) This time, the aliases you created are used.
1. Open a command window in BE_HOME/bin and run the yourname.sql script. (for example, @acme.sql). Use the user BE_USER, password BE_USER (or whatever username and password you set in the script in Task F).Complete this task only if you saw errors after completing Task J, Run the Project Schema Script (as BE_USER). Such errors are caused when your project ontology uses terms that are key words (reserved terms) in the DBMS you are using. You must map these terms to an alias in the keyword mapping file.
1.
2. Repeat Task H, Generate the Project-Schema-Specific SQL Scripts (with Wizard), and tasks following as needed.
Providing Project-Specific Key Word Aliases When you repeat Task H, the new key words are added to the yourname.aliases file. You can create project-specific aliases for the key word mappings as desired. Then repeat Task H again and continue.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |