Mainframe Software

IDMS SQL will support set relationships using foreign keys

By Steve Rundle posted 12-04-2014 04:50 PM

  

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 ;

0 comments
1 view