Résumé Preview
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.
Informations générales
-
État actuel : PubliéeDate de publication : 2016-12
-
Edition : 5
-
- ICS :
-
Langages utilisés dans les technologies de l'information
Acheter cette norme
Format | Langue | |
---|---|---|
- CHF198
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
PubliéeISO/IEC 9075-2:2016
Les normes ISO sont réexaminées tous les cinq ans
Stade: 90.92 (Sera révisée)Rectificatifs techniques / Amendements
PubliéeISO/IEC 9075-2:2016/Cor 1:2019
PubliéeISO/IEC 9075-2:2016/Cor 2:2022
-
Sera remplacée par
ProjetISO/IEC DIS 9075-2
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.