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 you are 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 on 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 you are editing an existing table, double click on the table object on the left pane to open the Properties dialog.
    • Click on the Override Create DDL tab.
    • Click on 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.

      Note

      The $OBJECT$ reference is auto translated to the fully qualified (schema/db.table name) at runtime.


      • For SQL Server and Oracle respectively, $FILEGROUP$ and $TABLESPACE$ get replaced at runtime with the storage defined values.
      • 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.

Tip

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


  • No labels