I just heard and seen a demo of a future IDMS 19.0 SQL facility:
SQL against a Schema defined to a Non-SQL database will support Set relationships via Primary and Foreign keys
This is big news! Standard SQL can now be used to access IDMS network defined databases.
Greg was at pains to explain that nothing described is guaranteed nor promised.
However the intention is for the first part of this facility wll be available in Early 2015
Very exciting.
EG:
SELECT * FROM DEPARTMENT D,
EMPLOYEE E
WHERE D.ROWID =
E.FKEY_SET_DEPT_EMPLOYEE ;