BNF Grammar for ISO/IEC 9075-1:2003 SQL/Foundation - Database Language SQL (SQL-2003) ===================================================================================== @(#)$Id: sql-2003-1.bnf,v 1.3 2009/06/24 17:15:49 jleffler Exp $ --p Information taken from the Final Committee Draft (FCD) of ISO/IEC 9075-1:2003. --/p --p The plain text version of this grammar is --## sql-2003-1.bnf . --/p --hr --h2 Identifying the version of SQL in use --/h2 --p This material (starting with ) is defined in section 6.3 "Object Identifier for Database Language SQL" of ISO/IEC 9075-1:1999 (SQL Framework). It is used to express the capabilities of an implementation. The package names are identifiers such as 'PKG001', equivalent to 'Enhanced datetime facilities', as defined in the informative Annex B to SQL Framework. Each such package identifies a number of features that are provided when the SQL object identifier claims to provide the package. --/p --hr --h2 6.3 Object identifier for Database Language SQL --/h2 ::= ::= ::= iso | 1 | iso 1 ::= standard | 0 | standard 0 ::= 9075 ::= ::= <1987> | <1989> | <1992> | <1999> | <200n> <1987> ::= 0 | edition1987 0 <1989> ::= <1989 base> <1989 package> <1989 base> ::= 1 | edition1989 1 <1989 package> ::= | ::= 0 | IntegrityNo 0 ::= 1 | IntegrityYes 1 <1992> ::= 2 | edition1992 2 ::= ::= | | ::= 0 | Low 0 ::= 1 | Intermediate 1 ::= 2 | High 2 <1999> ::= 3| edition1999 3 <2003> ::= 4| edition2003 4 ::= ::= | ... ::= | | | | | | ::= 1 | moduleAda 1 ::= 2 | moduleC 2 ::= 3 | moduleCOBOL 3 ::= 4 | moduleFortran 4 ::= 5 | moduleMUMPS 5 ::= 6 | modulePascal 6 ::= 7 | modulePLI 7 ::= | ... ::= | | | | | | ::= 1 | embeddedAda 1 ::= 2 | embeddedC 2 ::= 3 | embeddedCOBOL 3 ::= 4 | embeddedFortran 4 ::= 5 | embeddedMUMPS 5 ::= 6 | embeddedPascal 6 ::= 7 | embeddedPLI 7 ::= | ::= 1 | directyes 1 ::= 0 | directno 0 ::= | | | | | | ::= 1 | invokedAda 1 ::= 2 | invokedC 2 ::= 3 | invokedCOBOL 3 ::= 4 | invokedFortran 4 ::= 5 | invokedMUMPS 5 ::= 6 | invokedPascal 6 ::= 7 | invokedPLI 7 ::= ::= | ::= 0 | Part-nNo 0 ::= !! as specified in ISO/IEC 9075-n ::= ... ::= | --hr --h2 Annex B (informative) SQL Packages: --/h2 --## --## --## --## --## --## --## --## --## --## --##
1 PKG001 Enhanced datetime facilities
2 PKG002 Enhanced integrity management
3 PKG004 PSM
4 PKG005 CLI
5 PKG006 Basic object support
6 PKG007 Enhanced object support
7 PKG008 Active database
8 PKG009 SQL/MM support
9 PKG010 OLAP
--hr --h2 B.1 Enhanced datetime facilities --/h2 --p The package called "Enhanced datetime facilities" comprises the following features of the SQL language as specified in the SQL Feature Taxonomy Annex of the various parts of ISO/IEC 9075. --/p --p --## --## --## --## --##
Feature F052 Intervals and datetime arithmetic
Feature F411 Time zone specification
Feature F555 Enhanced seconds precision
--hr --h2 B.2 Enhanced integrity management --/h2 --p The package called "Enhanced integrity management" comprises the following features of the SQL language as specified in the SQL Feature Taxonomy Annex of the various parts of ISO/IEC 9075. --/p --p --## --## --## --## --## --## --## --## --## --## --##
Feature F191 Referential delete actions
Feature F521 Assertions
Feature F701 Referential update actions
Feature F491 Constraint management
Feature F671 Subqueries in CHECK constraints
Feature T201 Comparable data types for referential constraints
Feature T211 Basic trigger capability
Feature T212 Enhanced trigger capability
Feature T191 Referential action RESTRICT
--hr --h2 B.3 PSM --/h2 --p The package called "PSM" comprises the following features of the SQL language as specified in the SQL Feature Taxonomy Annex of the various parts of ISO/IEC 9075. --/p --p --## --## --## --## --## --##
Feature T322 Overloading of SQL-invoked functions and SQL-invoked procedures
Feature P001 Stored modules
Feature P002 Computational completeness
Feature P003 Information Schema views
--hr --h2 B.4 CLI --/h2 --p The package called "CLI" comprises the following features of the SQL language as specified in the SQL Feature Taxonomy Annex of the various parts of ISO/IEC 9075. --/p --p --## --## --## --## --## --## --## --## --##
Feature C011 SQL/CLI
Feature C021 Automatic population of Implementation Parameter Descriptor
Feature C041 Information Schema data controlled by current privileges
Feature C051 GetData extensions
Feature C061 GetParamData extensions
Feature C071 Scroll Concurrency
Feature C081 Read-only data source
--hr --h2 B.5 Basic object support --/h2 --p The package called "basic object support" comprises the following features of the SQL language as specified in the SQL Feature Taxonomy Annex of the various parts of ISO/IEC 9075. --/p --p --## --## --## --## --## --## --##
Feature S023 Basic structured types
Feature S041 Basic reference types
Feature S051 Create table of type
Feature S151 Type predicate
Feature T041 Basic LOB data type support
--hr --h2 B.6 Enhanced object support --/h2 --p The package called "enhanced object support" comprises all of the features of the package called (Basic object support), plus the following features of the SQL language as specified in the SQL Feature Taxonomy Annex of the various parts of ISO/IEC 9075. --/p --p --## --## --## --## --## --## --## --## --## --## --##
Feature S024 Enhanced structured types
Feature S043 Enhanced reference types
Feature S071 SQL-paths in function and type name resolution
Feature S081 Subtables
Feature S111 ONLY in query expressions
Feature S161 Subtype treatment
Feature S211 User-defined cast functions
Feature S231 Structured type locators
Feature S241 Transform functions
--hr --h2 B.7 Active database --/h2 --p The package called "Active database" comprises the following features of the SQL language as specified in the SQL Feature Taxonomy Annex of the various parts of ISO/IEC 9075. --/p --p --## --## --##
Feature T211 Basic trigger capability
--hr --h2 B.8 OLAP --/h2 --p The package called "OLAP" comprises the following features of the SQL language as specified in the SQL Feature Taxonomy Annex of the various parts of ISO/IEC 9075. --/p --p --## --## --## --##
Feature T431 Extended grouping capabilities
Feature T611 Elementary OLAP operators
--hr --h2 END OF SQL-2003-1 GRAMMAR --/h2 --hr