Publication CODE |
Title |
ISO/IEC 9075-2:2016 (2016-12) |
INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 2: FOUNDATION (SQL/FOUNDATION) |
|
Price Excl. VAT |
Total number of pages, tables and drawings |
229.00 €
|
1707 P.. |
Description
ISO/IEC 9075-2:2016 de?nes the data structures and basic operations on SQL-data. It provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data.
ISO/IEC 9075-2:2016 speci?es 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 which invoke an SQL externally-invoked procedure that, when executed, has an effect equivalent to exe-cuting the SQL-statement.
- For direct invocation of SQL-statements.
- To support dynamic preparation and execution of SQL-statements.
ISO/IEC 9075-2:2016 provides a vehicle for portability of data de?nitions and compilation units between SQL-implementations.
ISO/IEC 9075-2:2016 provides a vehicle for interconnection of SQL-implementations.
Implementations of this ISO/IEC 9075-2:2016 can exist in environments that also support application program-ming 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.
|
Class |
C990
(IEC PUBLICATIONS IEC PUBLICATIONS)
|
Committee |
ISO/IEC JTC 1/SC 32
DATA MANAGEMENT SERVICES
|
BEC Approval |
2016-12-14 |
Registration |
175086 |
ICS-Code (International Standards Classification) |
35.060
|
NBN Status |
New |
|
IEC publication date |
2016-12-14 |
|