WhereScape RED enables you to create tables, using a specific DDL statement instead of the RED generated DDL.
You can override and edit the created DDL on load, stage, data store, EDW 3NF, dimension, fact, aggregate, user-defined view, and retro table's Override Create DDL tab.

Creating a table using a specific DDL statement_

1. If creating a new table, drag and drop the table from the right pane to the middle pane.
   • On the Properties dialog, click on the Override Create DDL tab.
   • Click the Derive DDL button at the bottom of the dialog to get the generated DDL as your starting point.
   • Edit or clear the generated DDL and enter the desired DDL.
2. If editing an existing table, double-click on the table object on the left pane to open the Properties dialog.
   • Click the Override Create DDL tab.
   • Click the Derive DDL button at the bottom of the dialog to get the generated DDL as your starting point.
   • Edit or clear the generated DDL and enter the desired DDL.

   

   The $OBJECT$ reference is auto-translated to the fully qualified (schema/db.table name) at runtime. For DB2, $TABLESPACE$, and $INDEXSPACE$ get replaced at runtime with the storage-defined values. For Greenplum, OWNER gets replaced at runtime with the storage-defined values.

3. The "end of statement" indicator is <EOS> by default but can be configured in Tools > Options > Code Generation>General.
   

   To revert to RED deriving the original generated DDL at runtime, leave the Override DDL box blank or clear out the contents. Clicking the Derive DDL button pops up a warning message asking if you want to replace the current