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
superseded
A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.
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
06-01-2023
Language(s)
English
Published date
12-14-2016
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) |
| 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) |
| 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 |
| 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) |
| 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) |
| CSA ISO/IEC 9579 : 2004 : R2013 | INFORMATION TECHNOLOGY - REMOTE DATABASE ACCESS FOR SQL WITH SECURITY ENHANCEMENT |
| 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) |
| 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-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) |
| 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) |
| 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 |
| 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) |
| 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) |
US$73.00
Excluding Tax where applicable
USD
CAD
CHF
CNY
DKK
EUR
GBP
HKD
IDR
INR
JPY
KRW
MXN
NOK
NZD
SEK
SGD
USD
ZAR
Hardcopy - English
PDF - English
PDF 3 Users - English
PDF 5 Users - English
PDF 9 Users - English
01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Please Login or Create an Account so you can add users to your Multi user PDF Later.
Important note : All end users must be registered with an Account prior to user licenses being assigned.
Users cannot be edited or removed once added to your Multi user PDF.
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.