MDAC 2.5 SDK - OLE DB Programmer's Reference
Appendix B: Schema Rowsets


 

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

Default Sort Order: SQL_LANGUAGE_SOURCE