SQL_LANGUAGES Rowset

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"
"INTERMEDIATE"
"FULL"

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