Scenarios for Subsystems

Identifying All Persons from the Subsystem dms

Every object and relation type belongs to a subsystem. User-defined types always belong to the dms subsystem. This results in a more extensive notation for the following example:

SELECT [p]
FROM [person] AS [p]
//more detailed notation
SELECT [p]
FROM [dms]:[person] AS [p]

Identifying the Parent2Child Relation

In the org and dms subsystems, there is a relation type with the name Parent2Child that describes the structure of organization and business objects. The correct statements are as follows:

SELECT [p2c]
FROM [dms]:[sysParent2Child] AS [p2c]
//or
SELECT [p2c]
FROM [org]:[sysParent2Child] AS [p2c]