The SQL_LANGUAGES rowset identifies the conformance levels, options, and dialects supported by the SQL-implementation processing data defined in the catalog.
The SQL_LANGUAGES rowset contains the following columns.
Column name | Type indicator | Description |
SQL_LANGUAGE_ SOURCE |
DBTYPE_WSTR | Should be "ISO 9075" for standard SQL. |
SQL_LANGUAGE_YEAR | DBTYPE_WSTR | Should be "1992" for ANSI SQL92-compliant SQL. |
SQL_LANGUAGE_ CONFORMANCE |
DBTYPE_WSTR | One of the following:
"ENTRY" |
SQL_LANGUAGE_ INTEGRITY |
DBTYPE_WSTR | "YES"—Optional integrity feature is supported. "NO"—Optional integrity feature is not supported. |
SQL_LANGUAGE_ IMPLEMENTATION |
DBTYPE_WSTR | NULL for "ISO 9075" implementation. |
SQL_LANGUAGE_ BINDING_STYLE |
DBTYPE_WSTR | "DIRECT" for C/C++ callable direct execution of SQL. |
SQL_LANGUAGE_ PROGRAMMING_ LANGUAGE |
DBTYPE_WSTR | NULL. |
Default Sort Order: SQL_LANGUAGE_SOURCE