Mona Sivertsen wrote : >We are two students writing a project where we among other things are >supposed to compare SAP DB and its SQL features to SQL99. We are having >trouble comparing referential integrity - we can not find an option to >define ON UPDATE CASCADE, but we know there is a possibility to define ON >DELETE CASCADE. Is this feature also included in SAP DB or is there some >reson why it is not? Does SAP DB solve this in another way perhaps?
SAP DB does not support ON UPDATE CASCADE, but it supports ON DELETE CASCADE. ON UPDATE CASCADE is still on our TODO list. As a workaround you may implement this feature yourself using triggers. Regards, Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
