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.
Advertisement
Answer
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://en.wikipedia.org/wiki/SQL:2016
Hope that helps.