Blas Rodriguez Somoza wrote >Up to the date, DB2, postgresql and interbase has complete SQL/PSM support, whether Oracle claims that it PL/SQL is "similar" to PSM. Sybase and Microsoft follow >the TransactSQL and apparently don't want to support any ANSI/ISO standard more than ANSI92-Entry. >Standards is good for all, but specially for Open Source projects, because it makes easier to switch from one database to another. >I don't check the full SQL/PSM standard. But the following is a quick list of what SAPDB lacks of >CREATE PROCEDURE (as a synonym to CREATE DBPROC) DROP PROCEDURE (as a synonym to DROP DBPROC) >LEAVE (as a synonym to BREAK) >ELSEIF clausule at IF. >CASE statement. >LOOP statement. >FOR statement. >If there is any interest in standards compliance, I think those enhacements must be in the TODO list. >Does SAP want SAPDB to be standard compliant? Up to now SAPDB has no PSM standard support. If only the described features have to be supported, I don't see any problems to fulfill the standard. I will take this into account for the planned improvements of the procedure language. Thomas --- Thomas Anhaus SAPDB, SAP Labs Berlin
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
