Declarative Objectivity (DO) Language : Data Clauses
Data Clauses
Data clauses are the building blocks of data statements, which enable you to work with data stored in a federated database.
   
 
Statement
Clauses
Action
RETURN or SELECT
Specifies the result set of the query.
Identifies the query source.
Filters the query source.
Subdivides the result set into groups.
Orders the result set according to specified criteria.
Skip a specified portion of the result set.
Return a specified portion of the result set.
MATCH
MATCH Clause; see MATCH Statement
Specifies the pattern to match in a graph query.
CREATE
CREATE Clause; see CREATE Statement
Describes the persistent object to be created.
UPDATE
UPDATE Clause; see UPDATE Statement
Specifies persistent objects to be modified.
Sets attributes or collection elements to a specified value.
Sets attributes or collection elements to null or a default value.
Adds elements to a collection.
Removes elements from a collection.
DELETE
DELETE Clause; see DELETE Statement
Specifies persistent objects to be deleted.
LET
LET Clause; see LET Statement
Defines a parameter (named value) that can be used in another statement.
Note:Examples in the data-clause topics are based on the Rental Fleet Sample Schema.
Note:These clauses work with persistent data. For clauses that work with a federated database’s schema, see Schema Clauses.