3 ms·
Db2 actually implements SQL/PSM, which is more than can be said for Sybase/Microsoft SQL Server. I'm not sure if this extends to all three Db2 variants, namely
by chasil 3y ago
Db2 actually implements SQL/PSM, which is more than can be said for Sybase/Microsoft SQL Server.
I'm not sure if this extends to all three Db2 variants, namely Mainframe, AS/400 derivatives, and UDB for Linux and Windows (I hope so).
https://en.m.wikipedia.org/wiki/SQL/PSM https://en.m.wikipedia.org/wiki/SQL/PSM
IBM supposedly got the PSM code from EnterpriseDB/Postgres.
https://www.enterprisedb.com/news/enterprisedb-and-ibmr-collaborate-integrate-technology-new-version-db2 https://www.enterprisedb.com/news/enterprisedb-and-ibmr-coll...
https://www.internetnews.com/blog/ibm-gets-compatible-with-oracle-via-enterprisedb/ https://www.internetnews.com/blog/ibm-gets-compatible-with-o...
- lmz 3y agoWhat they got from EnterpriseDB is the Oracle (PL/SQL) compatibility. SQL/PSM was built by IBM themselves.
- cwbriscoe 3y agoThis is actually the first time I have heard of SQL/PSM. From Wiki, looks like it is for stored procedures. We do not do stored procedures at all on our DB2 instances. Heck, we don't even use triggers either. All our mainframe/DB2 business logic is in COBOL.
- simne 3y agoWow! I've worked with SMS sending gateway and cofounders cannot avoid temptation to use stored procedures for logic (we use Postgres, and logic in Perl). Because of this, last years installations limited by HDD performance, but fortunately, after crisis of 2008, we don't need much scaling.