SQL_LANGUAGES

The SQL_LANGUAGES table contains one row for every SQL language binding and programming language for which conformance is claimed.

The following table describes the columns in the SQL_LANGUAGES table:

Table 1. SQL_LANGUAGES table
Column Name Data Type Description
SQL_LANGUAGE_SOURCE VARCHAR(254) Name of the standard.
SQL_LANGUAGE_YEAR VARCHAR(254) Year in which the standard was approved.
SQL_LANGUAGE_CONFORMANCE VARCHAR(254)
Nullable
Level of conformance.
2
For the 1987 and 1989 standards, indicates that Level 2 conformance is claimed.
ENTRY
For the 1992 standard, indicates that Entry Level conformance is claimed.
CORE
For the 1999 standard, indicates that Core Level is conformance is claimed.

Contains the null value if conformance is not yet claimed.

SQL_LANGUAGE_INTEGRITY VARCHAR(254)
Nullable
Support of the integrity feature.
YES
conformance is claimed to the integrity feature
NO
conformance is not claimed to the integrity feature

Contains the null value if the standard does not have a separate integrity feature.

SQL_LANGUAGE_IMPLEMENTATION VARCHAR(254)
Nullable
Reserved. Contains the null value.
SQL_LANGUAGE_BINDING_STYLE VARCHAR(254) The style of binding of the SQL language
EMBEDDED
support for embedded SQL for the language in
SQL_LANGUAGE_PROGRAMMING_LANG
DIRECT
DIRECT SQL is supported (for example Interactive SQL)
CLI
Support for CLI for the language in
SQL_LANGUAGE_PROGRAMMING_LANG
SQL_LANGUAGE_PROGRAMMING_LANG VARCHAR(254)
Nullable
The language supported by EMBEDDED or CLI.
C
The C language is supported.
COBOL
The COBOL language is supported.
PLI
The PL/I language is supported.

Contains the null value if the SQL_LANGUAGE_BINDING_STYLE is DIRECT.