Page History
...
Pre/PostSQL Demonstrations for Selected Target Databases
- Insert Oracle Synonym in PostSQL
- Selectively Add DB2 Permissions to PostSQL
- Selectively Add MS SQL Permissions to PostSQL
- Selectively Add Oracle Permissions to PostSQL
- Selectively Add Oracle Sequence
- Selectively Add Sybase Permissions to PostSQL
Metadata Operations and Target Database Operations
| Operation | Description |
|---|---|
| Generate Partitions |
...
...
Provides and interface to add multiple partitions to clustered indexes. A list of tables is provided. Selecting a table will load the clustered indexes to be partitioned. The storage parameters are uniform across partitions. | |
| Get Related Tables |
...
Selects the related parents and/or child of the selected tables. To use the macro, lasso a group of entities on the diagram or select them in the diagram tree, and then right click on the macro to execute. Parents and children |
...
are selected depending if the option is checked. |
...
Use this macro |
...
to assist in submodel creation. |
...
| Import Data Dictionary | Import Data Dictionary objects from a flat file. The imported file has to follow a specific format guidelines listed in the comments with examples. |
| Index Naming |
...
Applies naming conventions to all types of indexes. It provides an option to use the selected tables or all tables. The prefix and suffix variables can be used to add company specific conventions to the beginning and/or end of the target name. The target name can be either the existing name, table name, tablespace name or database name. The tablespace and database can only be used for applicable platforms such as Oracle or DB2. Truncate parameters can also be specified to remove the first N characters or the last N characters of the target name. |
...
Use another parameter to limit the total number of characters in the target name. These are applied before the prefix and suffix are added. |
| Name Foreign Constraints |
...
Prompts the user with a dialog to specify the naming convention for Foreign Constraints. It |
...
then |
...
names all of the constraints using the parent and child table names |
...
and makes sure that the name is unique by adding an index for the last characters of duplicate names. |
| Name Primary Constraints |
...
Names all primary key constraints with the given naming conventions. The table name with either a prefix or suffix |
...
...
| Outputs DDL for primary and foreign constraints for all selected tables. To operate, selected the desired tables, then right-click on the macro to execute. The DDL can be previewed or written to a file. | |
| Selectively Update Oracle Index Storage |
...
| Provides a list of tables from the active physical model. The tables in the right box will be updated with the specified storage parameters. Tables can be added and removed from the updated list. | |
| Selectively Update OS390 Table Storage |
...
| Provides a list of tables from the active physical model. The tables in the right box will be updated with the specified storage parameters. Tables can be added and removed from the updated list. | |
| SQL Server Storage Update |
...
| Updates SQL Server storage parameters for tables and indexes. | |
| Switch Domain Bindings |
...
Scans all the columns and attributes in the active model or all models and switches the domain bindings from the source domain to the target domain. The information for each bound column will be updated with the target domain. Any domain overrides will be preserved. | |
| Update DB2 OS390 Index Storage Parameters |
...
| Provides a list of tables from the active physical model. The tables in the right box will be updated with the specified storage parameters. Tables can be added and removed from the updated list. | |
| Update DB2 OS390 Table Storage Parameters |
...
| Provides a list of tables from the active physical model. The tables in the right box will be updated with the specified storage parameters. Tables can be added and removed from the updated list. |