Norm

NEN-ISO/IEC 9075-2:2004 en

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

  • Deze norm is ingetrokken sinds 31-07-2008

164,52

Over deze norm

Status Ingetrokken
Aantal pagina's 580
Gepubliceerd op 01-01-2004
Taal Engels
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 otherwise conforms to the standard for a particular programming language (host language).- For deriving an equivalent compilation unit that conforms to the particular programming language standard. 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 may 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.

Details

ICS-code 35.060
Nederlandse titel Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)
Engelse titel Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)
Vervangt
Vervangen door
Gewijzigd door

Winkelwagen

Subtotaal:

Ga naar winkelwagen