Creating a CEAS (Create Entity As Select)

This section describes how to create a CEAS (Create Entity As Select). CEAS allows you to generate a new entity from the existing static entity according to the specified query.

Creating a CEAS

a. Open the menu on the upper right of the target entity from the top page of D-Ocean SDP and click [Query].

b. Enter any query in the text box. 。

c. Enter the name of any entity to be newly created in “save as.”

d. Select “CTAS” from the drop-down list and click the [Execute] button.

e. If the query is successful, a message is displayed at the bottom of the screen and a new entity is saved under MY ENTITIES.

Note :

  • Specify the prefix for the entity name in the FROM clause according to the scope.
    • My Entities: $
    • <Group>: $<group name>
    • Public: $public