ISO/IEC 9075-4:2016
Superseded
Superseded
A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.
View Superseded by
Information technology — Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM)
Amended by
Available format(s)
Hardcopy , PDF , PDF 3 Users , PDF 5 Users , PDF 9 Users
Superseded date
01-06-2023
Superseded by
Language(s)
English
Published date
14-12-2016
Important note : Users cannot be edited or removed once added to your Multi user PDF.
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 |
Superseded
|
| 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 |
| CAN/CSA-ISO/IEC 9075-4:18 | 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) |
| CAN/CSA-ISO/IEC 9075-1:18 | Information technology - Database languages - SQL - Part 1: Framework (SQL/Framework) (Adopted ISO/IEC 9075-1:2061, fifth edition, 2016-12-15) |
| CAN/CSA-ISO/IEC 9075-10:18 | Information technology - Database languages - SQL - Part 10: Object language bindings (SQL/OLB) (Adopted ISO/IEC 9075-10:2016, fourth edition, 2016-12-15) |
| CAN/CSA-ISO/IEC 9075-14:18 | Information technology - Database languages - SQL - Part 14: XML-related specifications (SQL/XML) (Adopted ISO/IEC 9075-14:2016, fifth edition, 2016-12-15) |
| CAN/CSA-ISO/IEC 9579-04 (R2018) | Information Technology - Remote Database Access for SQL with Security Enhancement (Adopted ISO/IEC 9579:2000, second edition, 2000-02-15) |
| CSA ISO/IEC 9579 : 2004 : R2013 | INFORMATION TECHNOLOGY - REMOTE DATABASE ACCESS FOR SQL WITH SECURITY ENHANCEMENT |
| CAN/CSA-ISO/IEC 9075-2:18 | Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation) (Adopted ISO/IEC 9075-2:2016, fifth edition, 2016-12-15) |
| 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) |
Access your standards online with a subscription
Features
-
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.