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.
- Specify the prefix for the entity name in the FROM clause according to the scope.
- My Entities: $
- <Group>: $<group name>
- Public: $public