🔥🔥 Don’t Miss Out on Our End of Autumn Sale. If you have any questions, feel free to click the bottom right corner to contact our customer service..

Concat us[email protected]
Shopping Cart

No products in the cart.

🔍
BSI 22/30430210 DC:2022 Edition

BSI 22/30430210 DC:2022 Edition

$24.66

BS ISO/IEC 9075-4. Information technology. Database languages. SQL – Part 4. Persistent stored modules (SQL/PSM)

Published By Publication Date Number of Pages
BSI 2022 172
PDF Format Searchable Printable Preview Now
Guaranteed Safe Checkout
Category:

If you have any questions, feel free to reach out to our online customer service team by clicking on the bottom right corner. We’re here to assist you 24/7.
Email:[email protected]

PDF Catalog

PDF Pages PDF Title
1 30430210-NC.pdf
3 ISO_IEC DIS 9075-4 ed.7 – id.76585 Enquiry PDF (en).pdf
5 Contents
9 Tables
10 Foreword
12 Introduction
15 1 Scope
16 2 Normative references
17 3 Terms and definitions
18 4 Concepts
4.1 Notations and conventions
4.1.1 Notations
4.1.2 Use of terms
4.2 SQL-server modules
19 4.3 Tables
4.3.1 Base tables
4.3.1.1 Temporary tables
4.3.2 Unique identification of tables
4.4 SQL-schemas
20 4.5 SQL-invoked routines
4.5.1 Overview of SQL-invoked routines
4.5.2 Execution of conventional SQL-invoked routines
4.5.3 Routine descriptors
4.6 SQL-paths
4.7 Host parameters
4.7.1 Status parameters
4.8 Diagnostics area
21 4.9 Condition handling
22 4.10 Cursors
4.10.1 General description of cursors
23 4.11 SQL-statements
4.11.1 Classes of SQL-statements
4.11.2 SQL-statements classified by function
4.11.2.1 SQL-schema statements
4.11.2.2 SQL-control statements
4.11.2.3 SQL-control declarations
24 4.11.2.4 SQL-diagnostics statements
4.11.3 SQL-statements and transaction states
4.11.4 SQL-statement atomicity and statement execution contexts
4.11.5 Embeddable SQL-statements
25 4.11.6 Preparable and immediately executable SQL-statements
4.11.7 Directly executable SQL-statements
4.11.8 Iterated SQL-statements
4.11.9 Compound statements
26 4.12 Basic security model
4.12.1 Privileges
4.13 SQL-sessions
4.13.1 General description of SQL-sessions
27 5 Lexical elements
5.1 and
29 5.2 Names and identifiers
31 6 Scalar expressions
6.1 and
33 6.2
35 6.3
36 6.4
37 7 Query expressions
7.1

38 7.2
39 8 Additional common rules
8.1 Potential sources of non-determinism
40 8.2 Executing an
41 8.3 Invoking an SQL-invoked routine
42 8.4 Transformation of query specifications
43 8.5 Handler execution
46 9 Additional common elements
9.1
48 10 Schema definition and manipulation
10.1
49 10.2
50 10.3

51 10.4
52 10.5
53 10.6
54 10.7
55 10.8
56 10.9
57 10.10
58 10.11
59 10.12
60 10.13
61 10.14
62 10.15
63 10.16
64 10.17
65 10.18
66 10.19
67 10.20
68 10.21
71 10.22
72 10.23
73 10.24
75 10.25
76 10.26
77 11 Access control
11.1
78 11.2
79 11.3
83 12 SQL-client modules
12.1
85 12.2
86 13 Data manipulation
13.1
87 13.2
88 13.3
89 13.4
90 13.5
91 13.6
92 13.7
93 13.8
94 14 Additional data manipulation rules
14.1 Effect of opening a cursor
95 15 Control statements
15.1
99 15.2
101 15.3
102 15.4
103 15.5
107 15.6
110 15.7
112 15.8
113 15.9
114 15.10
115 15.11
117 15.12
118 15.13
121 16 Dynamic SQL
16.1
123 16.2
124 16.3
125 17 Embedded SQL
17.1
127 18 Diagnostics management
18.1
129 18.2
131 18.3
133 19 Information Schema
19.1 Information Schema digital artifact
19.2 MODULE_COLUMN_USAGE view
135 19.3 MODULE_PRIVILEGES view
136 19.4 MODULE_TABLE_USAGE view
137 19.5 MODULES view
138 19.6 PARAMETERS view
139 19.7 ROLE_MODULE_GRANTS view
140 19.8 ROUTINES view
141 19.9 Short name views
142 20 Definition Schema
20.1 Definition Schema digital artifact
20.2 MODULE_COLUMN_USAGE base table
144 20.3 MODULE_PRIVILEGES base table
146 20.4 MODULE_TABLE_USAGE base table
147 20.5 MODULES base table
149 20.6 ROUTINES base table
150 21 Status codes
21.1 SQLSTATE
151 22 Conformance
22.1 Claims of conformance to SQL/PSM
22.2 Additional conformance requirements for SQL/PSM
22.3 Implied feature relationships of SQL/PSM
153 22.4 Syntactic transformations applied before Conformance Rules in SQL/PSM
154 A SQL Conformance Summary
159 B Implementation-defined elements
161 C Implementation-dependent elements
163 D SQL optional feature taxonomy
165 E Deprecated features
166 F Incompatibilities with ISO/IEC 9075:2011
167 G Defect reports not addressed in this edition of this document
168 Bibliography
169 Index

Related products

BSI 22/30430210 DC
$24.66