SQL_LANGUAGES_S

Information on the implemented host languages and embedments. All designations are defined in the SQL standard.

Column name

Data type

Contents

SOURCE

VARCHAR (256)

ISO standard:
'ISO 9075’

SQL_LANGUAGE_YEAR

VARCHAR (256)

Year in which standard appeared:
'1989'
'1992'
'1999'
'2008'

CONFORMANCE

VARCHAR (256)

Language scope:
'2'
'ENTRY'
'CORE'

INTEGRITY

VARCHAR (256)

'YES'

SQL89 “integrity enhancement” implemented

NULL value

if SQL_LANGUAGE_YEAR ≠
'1989'

IMPLEMENTATION

VARCHAR (256)

Specification of an implementationdefined
standard,
if SOURCE ≠ 'ISO 9075'

BINDING_STYLE

VARCHAR (256)

Type of embedment:
'EMBEDDED'

PROGRAMMING_
LANGUAGE

VARCHAR (256)

Supported programming language:
'COBOL'

Table 92: SQL_LANGUAGES_S view of the INFORMATION_SCHEMA