GUID: DBSCHEMA_SQL_LANGUAGES
Number of restriction columns: 0
Restriction columns: none
Default sort order: SQL_LANGUAGE_SOURCE
Description: The SQL_LANGUAGES rowset identifies the conformance levels, options, and dialects supported by the SQL-implementation processing data defined in the catalog.
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 SQL-92–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. |