Search code examples
sqldb2ibm-cloud

What is the SQL dialect used in IBM Db2 on Cloud


Does anyone know what is the SQL dialect used in IBM Db2 on Cloud?

I tried googling and also found this stackoverflow link but couldn't see any references in the link to what SQL dialect is being used in IBM Db2 on Cloud.

Many thanks in advance.


Solution

  • I have used IBM DB2 on Cloud in the past. What I realized is that they follow most of the SQL standards but as any of the other SQL dialects, they also add a bit of their own flavors. I hope that made sense.

    That being said, looks that for the most part, they follow the SQL 2016 standard. Here are a couple of references:

    https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/home/src/cmn/db2z_industrystandardsdb2.html

    https://en.wikipedia.org/wiki/SQL:2016

    Hope that helps.