Standards compliances for Db2 Warehouse

Db2® Warehouse complies with standards for its SQL, connection protocols, data formats, and client interfaces.

Db2 Warehouse is compliant with the following standards:
  • ANSI/ISO SQL 92 Entry via FIPS 127.2 Entry
  • JDBC
  • Object Management Group (OMG) Common Warehouse Metadata Interchange (CWMI)
  • Open Geospatial Consortium (OGC)
  • ISO SQL/MM part 3: Spatial
  • SQLJ is compliant to ISO/IEC 9075-10:2003. Specification dated 2003/07/25. "Information technology - Database languages - SQL - Part 10: Object Language Bindings (SQL/OLB)"
  • X/OPEN CLI (Call Level Interface)
  • X/Open XA