ISO/IEC 9075-2

Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)

active, Most Current
Buy Now
Organization: ISO
Publication Date: 15 December 2016
Status: active
Page Count: 1,732
ICS Code (Languages used in information technology): 35.060
scope:

This part of ISO/IEC 9075 defines the data structures and basic operations on SQL-data. It provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data.

This part of ISO/IEC 9075 specifies the syntax and semantics of a database language:

- For specifying and modifying the structure and the integrity constraints of SQL-data.

- For declaring and invoking operations on SQL-data and cursors.

- For declaring database language procedures.

- For embedding SQL-statements in a compilation unit that is otherwise written in a particular programming language (host language).

- For deriving an equivalent compilation unit in the host language. In that equivalent compilation unit, each embedded SQL-statement has been replaced by one or more statements in the host language, some of which invoke an SQL externally-invoked procedure that, when executed, has an effect equivalent to executing the SQL-statement.

- For direct invocation of SQL-statements.

- To support dynamic preparation and execution of SQL-statements.

This part of ISO/IEC 9075 provides a vehicle for portability of data definitions and compilation units between SQL-implementations.

This part of ISO/IEC 9075 provides a vehicle for interconnection of SQL-implementations.

Implementations of this part of ISO/IEC 9075 can exist in environments that also support application programming languages, end-user query languages, report generator systems, data dictionary systems, program library systems, and distributed communication systems, as well as various tools for database design, data administration, and performance optimization.

Document History

ISO/IEC 9075-2
December 15, 2016
Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)
This part of ISO/IEC 9075 defines the data structures and basic operations on SQL-data. It provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data....
October 1, 2015
Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation) TECHNICAL CORRIGENDUM 2
A description is not available for this item.
December 15, 2013
Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation) TECHNICAL CORRIGENDUM 1
A description is not available for this item.
December 15, 2011
Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)
This part of ISO/IEC 9075 defines the data structures and basic operations on SQL-data. It provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data....
June 1, 2010
Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation) TECHNICAL CORRIGENDUM 1
A description is not available for this item.
July 15, 2008
Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)
A description is not available for this item.
April 15, 2007
Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation) TECHNICAL CORRIGENDUM 2
A description is not available for this item.
November 15, 2005
Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation) TECHNICAL CORRIGENDUM 1
A description is not available for this item.
December 15, 2003
Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)
A description is not available for this item.
June 1, 2003
Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation) AMENDMENT 1: On-Line Analytical Processing (SQL/OLAP) TECHNICAL CORRIGENDUM 1
A description is not available for this item.
June 1, 2003
Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation) TECHNICAL CORRIGENDUM 2
A description is not available for this item.
March 15, 2001
Information technology - Database languages - SQL - Part 1: Framework (SQL/Framework) Part 2: Foundation (SQL/Foundation) Part 5: Host Language Bindings (SQL/Bindings) AMENDMENT 1: On-Line Analytical Processing (SQL/OLAP)
A description is not available for this item.
December 15, 2000
Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation) TECHNICAL CORRIGENDUM 1
A description is not available for this item.
December 1, 1999
Information Technology - Database Languages - SQL - Part 2: Foundation (SQL/Foundation)
A description is not available for this item.

References

Advertisement