ISO/IEC 9075-4:2016
Withdrawn
Withdrawn
A Withdrawn Standard is one, which is removed from sale, and its unique number can no longer be used. The Standard can be withdrawn and not replaced, or it can be withdrawn and replaced by a Standard with a different number.
View Superseded by
Information technology — Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM)
Amended by
Available format(s)
Hardcopy , PDF
Language(s)
English
Published date
14-12-2016
Withdrawn date
01-06-2023
Superseded by
€63.00
Excluding VAT
ISO/IEC 9075-4:2016 specifies the syntax and semantics of a database language for declaring and maintaining persistent database language routines in SQL-server modules.
The database language for s and s includes:
- The specification of statements to direct the flow of control.
- The assignment of the result of expressions to variables and parameters.
- The specification of condition handlers that allow SQL-invoked routines to deal with various conditions that arise during their execution.
- The specification of statements to signal and resignal conditions.
- The declaration of standing SQL-server cursors.
- The declaration of local variables.
It also includes the definition of the Information Schema tables that contain schema information pertaining to SQL-server modules and SQL-invoked routines.
| Committee |
ISO/IEC JTC 1/SC 32
|
| DevelopmentNote |
Supersedes ISO/IEC 9075. (04/2001)
|
| DocumentType |
Standard
|
| Pages |
188
|
| PublisherName |
International Organization for Standardization
|
| Status |
Withdrawn
|
| SupersededBy | |
| Supersedes |
| Standards | Relationship |
| NEN-ISO/IEC 9075-4:2016 | Identical |
| JIS X 3005-4:2019 | Identical |
| BS ISO/IEC 9075 1-4,9-11,13-14:2010 | Identical |
| BS ISO/IEC 9075-4:1999 | Identical |
| BS ISO/IEC 9075 1-4, 9-11, 13-14:2016 | Identical |
| INCITS/ISO/IEC 9075-4 : 2012 | Identical |
| ISO/IEC 9075-10:2016 | Information technology — Database languages — SQL — Part 10: Object language bindings (SQL/OLB) |
| BS ISO 19125-2 : 2004 AMD 16387 | GEOGRAPHIC INFORMATION - SIMPLE FEATURE ACCESS - PART 2: SQL OPTION |
| BS ISO/IEC 9075-9:2001 | Information technology. Database languages. SQL Management of external data (SQL/MED) |
| INCITS/ISO/IEC 9075-2 : 2012 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 2: FOUNDATION (SQL/FOUNDATION) |
| ISO/IEC 9579:2000 | Information technology — Remote database access for SQL with security enhancement |
| BS ISO/IEC 9075-10:2000 | Information technology. Database languages. SQL Object Language Bindings (SQL/OLB) |
| INCITS/ISO/IEC 9075-1 : 2012 | INFORMATION TECHNOLOGY- DATABASE LANGUAGES - SQL - PART 1: FRAMEWORK (SQL/FRAMEWORK) |
| INCITS/ISO/IEC 9075-14 : 2012 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 14: XML-RELATED SPECIFICATIONS (SQL/XML) |
| 02/656424 DC : DRAFT FEB 2002 | ISO/IEC FCD 13249-1 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL MULTIMEDIA AND APPLICATION PACKAGES - PART 1: FRAMEWORK |
| BS ISO/IEC 9075-3:1999 | Information technology. Database languages. SQL Call-level interface (SQL/CLI) |
| BS ISO/IEC 9579/2 : 1998 | INFORMATION TECHNOLOGY - OPEN SYSTEMS INTERCONNECTION - REMOTE DATABASE ACCESS - SQL SPECIALIZATION |
| 09/30142058 DC : 0 | ISO/IEC 13249-7 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL MULTIMEDIA AND APPLICATION PACKAGES - PART 7: HISTORY |
| BS ISO/IEC 9075-1 : 2016 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 1: FRAMEWORK (SQL/FRAMEWORK) |
| I.S. EN ISO 19125-2:2006 | GEOGRAPHIC INFORMATION - SIMPLE FEATURE ACCESS - PART 2: SQL OPTION |
| ISO/IEC 9075-2:2016 | Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation) |
| ISO/IEC 9579-2:1998 | Information technology — Open Systems Interconnection — Remote Database Access — Part 2: SQL Specialization |
| 10/30202054 DC : 0 | BS ISO/IEC 9075-14 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 14: XML-RELATED SPECIFICATIONS (SQL/XML) |
| ANSI INCITS 331.1 : 1999 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQLJ - PART 1: SQL ROUTINES USING THE JAVA PROGRAMMING LANGUAGE |
| INCITS/ISO/IEC 9075-5 : 1999 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 5: HOST LANGUAGE BINDINGS (SQL/BINDINGS) |
| 10/30202041 DC : 0 | BS ISO/IEC 9075-2 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 2: FOUNDATION (SQL/FOUNDATION) |
| ISO/IEC TR 10182:2016 | Information technology — Programming languages, their environments and system software interfaces — Guidelines for language bindings |
| 10/30202037 DC : 0 | BS ISO/IEC 9075-1 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 1: FRAMEWORK (SQL/FRAMEWORK) |
| PD ISO/IEC TS 13249-7:2013 | Information technology. Database languages. SQL multimedia and application packages History |
| BS ISO/IEC 9579:2000 | Information technology. Remote database access for SQL with security enhancement |
| BS ISO/IEC 9075-5:1999 | Information technology. Database languages. SQL Host language bindings (SQL/Bindings) |
| PD ISO/IEC TR 10182:2016 | Information technology. Programming languages, their environments and system software interfaces. Guidelines for language bindings |
| 07/30082615 DC : 0 | BS ISO/IEC 9075-1 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 1: FRAMEWORK (SQL/FRAMEWORK) |
| 15/30279742 DC : 0 | BS ISO/IEC 9075-1 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 1: FRAMEWORK (SQL/FRAMEWORK) |
| 05/30082714 DC : DRAFT MAY 2005 | ISO/IEC 13249-1 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL MULTIMEDIA AND APPLICATION PACKAGES - PART 1: FRAMEWORK |
| ANSI INCITS 331.2 : 2000 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQLJ - PART 2: SQL TYPES USING THE JAVA TM PROGRAMMING LANGUAGE |
| 07/30133722 DC : 0 | BS ISO/IEC 9075-14 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 14: XML - RELATED SPECIFICATIONS (SQL/XML) |
| INCITS/ISO/IEC 13249-5 : 2001 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL MULTIMEDIA AND APPLICATION PACKAGES - PART 5: STILL IMAGE |
| ISO/IEC TS 13249-7:2013 | Information technology — Database languages — SQL multimedia and application packages — Part 7: History |
| ISO/TS 15000-4:2004 | Electronic business eXtensible Markup Language (ebXML) — Part 4: Registry services specification (ebRS) |
| ISO 19125-2:2004 | Geographic information — Simple feature access — Part 2: SQL option |
| BS EN ISO 19125-2:2006 | Geographic information. Simple feature access SQL option |
| EN ISO 19125-2:2006 | Geographic information - Simple feature access - Part 2: SQL option (ISO 19125-2:2004) |
| ISO/IEC 9075-1:2016 | Information technology — Database languages — SQL — Part 1: Framework (SQL/Framework) |
| INCITS/ISO/IEC 9075-10 : 2008 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 10: OBJECT LANGUAGE BINDINGS (SQL/OLB) |
| ANSI INCITS 500 : 2012 | INFORMATION TECHNOLOGY - DATABASE LANGUAGE SQL - ROW PATTERN RECOGNITION (SQL/RPR) |
| INCITS/ISO 19125-2 : 2004 | GEOGRAPHIC INFORMATION - SIMPLE FEATURE ACCESS - PART 2: SQL OPTION |
| ISO/IEC 9075-5:1999 | Information technology — Database languages — SQL — Part 5: Host Language Bindings (SQL/Bindings) |
| ISO/IEC 9075-14:2016 | Information technology — Database languages — SQL — Part 14: XML-Related Specifications (SQL/XML) |
| ISO/IEC 9075-2:2016 | Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation) |
| ISO/IEC 9075-11:2016 | Information technology — Database languages — SQL — Part 11: Information and definition schemas (SQL/Schemata) |
| ISO/IEC 9075-1:2016 | Information technology — Database languages — SQL — Part 1: Framework (SQL/Framework) |
Summarise
Access your standards online with a subscription
-
Simple online access to standards, technical information and regulations.
-
Critical updates of standards and customisable alerts and notifications.
-
Multi-user online standards collection: secure, flexible and cost effective.
Important note : Users cannot be edited or removed once added to your Multi user PDF.