Standard: ISO/IEC 9075-2

INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 2: FOUNDATION (SQL/FOUNDATION)

This standard is available for individual purchase.

or unlock this standard with a subscription to IHS Standards Expert

IHS Standards Expert subscription, simplifies and expedites the process for finding and managing standards by giving you access to standards from over 370 standards developing organizations (SDOs).

FEATURES & BENEFITS
  • Maximize product development and R&D with direct access to over 1.6 million standards
  • Discover new markets: Identify unmet needs and discover next-generation technologies
  • Improve quality by leveraging consistent standards to meet customer and market requirements
  • Minimize risk: Mitigate liability and better understand compliance regulations
  • Boost efficiency: Speed up research, capture and reuse expertise
For additional product information, visit the IHS Standards Expert page.

HOW TO SUBSCRIBE
For more information or a custom quote, visit the IHS Contact Us page for regional contact information.
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.

Organization: International Organization for Standardization
Document Number: iso/iec 9075-2
Publish Date: 2016-12-15
Page Count: 1732
Change Type: COMPLETE REVISION
Available Languages: EN
DOD Adopted: NO
ANSI Approved: NO
Most Recent Revision: YES
Current Version: YES
Status: Active

Document History

Document # Change Type Update Date Revision Status
ISO/IEC 9075-2 Change Type: COR2 Revision: 4TH Status: INAC
ISO/IEC 9075-2 Change Type: COR2 Update Date: 2015-10-01 Revision: 4TH Status: INAC
ISO/IEC 9075-2 Change Type: COR1 Update Date: 2013-12-15 Revision: 4TH Status: INAC
ISO/IEC 9075-2 Change Type: STCH Update Date: 2011-12-15 Revision: 4TH Status: INAC
ISO/IEC 9075-2 Change Type: COR Revision: 3RD Status: INAC
ISO/IEC 9075-2 Change Type: COR Update Date: 2010-06-01 Revision: 3RD Status: INAC
ISO/IEC 9075-2 Change Type: STCH Update Date: 2008-07-15 Revision: 3RD Status: INAC
ISO/IEC 9075-2 Change Type: COR Revision: 2ND Status: INAC
ISO/IEC 9075-2 Change Type: COR Update Date: 2007-04-15 Revision: 2ND Status: INAC
view more
Advertisement
Advertisement
Advertisement
Advertisement