Sample pluglets

Changing the owning schema

You can also reassign all indexes, tables, and views in a physical data model, database, or location from the model, database, or location node.

You can also reassign one or more objects that are owned by another schema by selecting those objects and running the pluglet at that level.

Changing the supporting table space

To assign the tables in a physical data model, database, or location to an existing table space, run the sample pluglet.

Naming indexes

Use this sample to name the indexes in a selected physical data model, database or location, or schema.

Updating foreign key documentation

Run this pluglet from the entity or table level to copy the documentation from parent keys to foreign keys.

Removing auxiliary tables

Run this pluglet from the DB2 for z/OS physical data model or location node to remove all auxiliary tables and the associated table spaces in the model or location.

Setting attributes to required

Run this pluglet at the entity level to specify that all attributes in the entity are required.

Setting columns to not null

Run this pluglet at the table level to specify that all columns in the table are not null.

Calculating table data (column length, table row length, table row size)

Run this pluglet to calculate information about the tables in a physical data model, database, or location and export that information to a CSV file that is stored in a location that you specify.

This pluglet can calculate the table row length, table row size, and column length.

Selecting objects by name

Run this pluglet from the Data Project Explorer or the diagram editor to select objects by name according to rules that you specify.

Applying appearance attributes to all subtype entities in a diagram

You can apply the appearance properties of supertype entities in generalization relationships to all subtype entities. In the diagram editor, right-click a diagram that contains a generalization relationship, or right-click a subtype entity that belongs to a generalization relationship and run the pluglet.

Specifying a font color for nonpersistent attributes in a diagram

You can specify a font color for all nonpersistent attributes that exist in a diagram. In the diagram editor, right-click a diagram that contains nonpersistent attributes, or right-click an entity that contains nonpersistent attributes.