Hacker News Reader

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

IBM supposedly got the PSM code from EnterpriseDB/Postgres.

https://www.enterprisedb.com/news/enterprisedb-and-ibmr-coll...

https://www.internetnews.com/blog/ibm-gets-compatible-with-o...

View on HN

What they got from EnterpriseDB is the Oracle (PL/SQL) compatibility. SQL/PSM was built by IBM themselves.

This 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.

Wow! 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.

Reply on news.ycombinator.com