SQL_LANGUAGES Rowset

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"

  • "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.

Show: