Yesterday was one of those days when I, again, worked as information broker. I received a question, asked around myself, passed on information that I learned, and finally handed back an answer to the originator. With this blog post, I am closing the loop and share what I learned. A, I forgot, it is about the Db2 documentation.
Db2 documentation online
You probably know that you can find the Db2 documentation online in the new documentation center. There, you find, e.g.,
- Db2 11.5 documentation,
- Db2 on Cloud documentation,
- Db2 Warehouse on Cloud documentation,
- IBM Cloud Pak for Data documentation,
- IBM Informix Server documentation.
You can access the full list of products here. Unfortunately to many, the Db2 documentation is no longer available as PDF books. The page Db2 Version 11.1 for Linux, UNIX, and Windows English Manuals hosts PDF manuals, but only for the older Db2 version.
SQL PL and PL/SQL
It includes a great introduction to PL/SQL, the Oracle procedural language supported by Db2. Do we have something similar for SQL PL, THE Db2 procedural language? Yes, there is - but not as part of the Db2 11.1 collection. It is available for Db2 11.5 as PDF: Db2 11.5 SQL PL.
So if you want to read a good overview of SQL PL and how to use it, start with that linked PDF book.
I close with pointing to my old blog on my best practices to search the Db2 documentation.
Originally published on Data Henrik Blog.