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_
- 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.
- 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.
- 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