Résumé
ISO/IEC 9075-2:2016 defines 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 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 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 definitions 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.
-
État actuel: AnnuléeDate de publication: 2016-12
-
Edition: 5
-
- ICS :
- 35.060 Langages utilisés dans les technologies de l'information
Cycle de vie
-
Précédemment
AnnuléeISO/IEC 9075-2:2011
AnnuléeISO/IEC 9075-2:2011/Cor 1:2013
AnnuléeISO/IEC 9075-2:2011/Cor 2:2015
-
Actuellement
-
00
Préliminaire
-
10
Proposition
-
20
Préparation
-
30
Comité
-
40
Enquête
-
50
Approbation
-
60
Publication
-
90
Examen
-
95
Annulation
Rectificatifs techniques / Amendements
AnnuléeISO/IEC 9075-2:2016/Cor 1:2019
AnnuléeISO/IEC 9075-2:2016/Cor 2:2022
-
00
-
Révisée par
PubliéeISO/IEC 9075-2:2023
Vous avez une question?
Consulter notre FAQ
Horaires d’ouverture:
De lundi à vendredi - 09:00-12:00, 14:00-17:00 (UTC+1)
Suivez l'actualité de l'ISO
Inscrivez-vous à notre Newsletter (en anglais) pour suivre nos actualités, points de vue et informations sur nos produits.