{"id":409613,"date":"2024-10-20T05:36:26","date_gmt":"2024-10-20T05:36:26","guid":{"rendered":"https:\/\/pdfstandards.shop\/product\/uncategorized\/bsi-22-30430210-dc\/"},"modified":"2024-10-26T10:17:33","modified_gmt":"2024-10-26T10:17:33","slug":"bsi-22-30430210-dc","status":"publish","type":"product","link":"https:\/\/pdfstandards.shop\/product\/publishers\/bsi\/bsi-22-30430210-dc\/","title":{"rendered":"BSI 22\/30430210 DC"},"content":{"rendered":"

PDF Catalog<\/h4>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
PDF Pages<\/th>\nPDF Title<\/th>\n<\/tr>\n
1<\/td>\n30430210-NC.pdf <\/td>\n<\/tr>\n
3<\/td>\nISO_IEC DIS 9075-4 ed.7 – id.76585 Enquiry PDF (en).pdf <\/td>\n<\/tr>\n
5<\/td>\nContents <\/td>\n<\/tr>\n
9<\/td>\nTables <\/td>\n<\/tr>\n
10<\/td>\nForeword <\/td>\n<\/tr>\n
12<\/td>\nIntroduction <\/td>\n<\/tr>\n
15<\/td>\n1 Scope <\/td>\n<\/tr>\n
16<\/td>\n2 Normative references <\/td>\n<\/tr>\n
17<\/td>\n3 Terms and definitions <\/td>\n<\/tr>\n
18<\/td>\n4 Concepts
4.1 Notations and conventions
4.1.1 Notations
4.1.2 Use of terms
4.2 SQL-server modules <\/td>\n<\/tr>\n
19<\/td>\n4.3 Tables
4.3.1 Base tables
4.3.1.1 Temporary tables
4.3.2 Unique identification of tables
4.4 SQL-schemas <\/td>\n<\/tr>\n
20<\/td>\n4.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 <\/td>\n<\/tr>\n
21<\/td>\n4.9 Condition handling <\/td>\n<\/tr>\n
22<\/td>\n4.10 Cursors
4.10.1 General description of cursors <\/td>\n<\/tr>\n
23<\/td>\n4.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 <\/td>\n<\/tr>\n
24<\/td>\n4.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 <\/td>\n<\/tr>\n
25<\/td>\n4.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 <\/td>\n<\/tr>\n
26<\/td>\n4.12 Basic security model
4.12.1 Privileges
4.13 SQL-sessions
4.13.1 General description of SQL-sessions <\/td>\n<\/tr>\n
27<\/td>\n5 Lexical elements
5.1 and <\/td>\n<\/tr>\n
29<\/td>\n5.2 Names and identifiers <\/td>\n<\/tr>\n
31<\/td>\n6 Scalar expressions
6.1 and <\/td>\n<\/tr>\n
33<\/td>\n6.2 <\/td>\n<\/tr>\n
35<\/td>\n6.3 <\/td>\n<\/tr>\n
36<\/td>\n6.4 <\/td>\n<\/tr>\n
37<\/td>\n7 Query expressions
7.1 <\/p>\n <\/td>\n<\/tr>\n\n\n\n\n\n\n\n\n\n\n
38<\/td>\n7.2 <\/td>\n<\/tr>\n
39<\/td>\n8 Additional common rules
8.1 Potential sources of non-determinism <\/td>\n<\/tr>\n
40<\/td>\n8.2 Executing an <\/td>\n<\/tr>\n
41<\/td>\n8.3 Invoking an SQL-invoked routine <\/td>\n<\/tr>\n
42<\/td>\n8.4 Transformation of query specifications <\/td>\n<\/tr>\n
43<\/td>\n8.5 Handler execution <\/td>\n<\/tr>\n
46<\/td>\n9 Additional common elements
9.1 <\/td>\n<\/tr>\n
48<\/td>\n10 Schema definition and manipulation
10.1 <\/td>\n<\/tr>\n
49<\/td>\n10.2 <\/td>\n<\/tr>\n
50<\/td>\n10.3 <\/p>\n <\/td>\n<\/tr>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
51<\/td>\n10.4 <\/td>\n<\/tr>\n
52<\/td>\n10.5 <\/td>\n<\/tr>\n
53<\/td>\n10.6 <\/td>\n<\/tr>\n
54<\/td>\n10.7 <\/td>\n<\/tr>\n
55<\/td>\n10.8 <\/td>\n<\/tr>\n
56<\/td>\n10.9 <\/td>\n<\/tr>\n
57<\/td>\n10.10 <\/td>\n<\/tr>\n
58<\/td>\n10.11 <\/td>\n<\/tr>\n
59<\/td>\n10.12 <\/td>\n<\/tr>\n
60<\/td>\n10.13 <\/td>\n<\/tr>\n
61<\/td>\n10.14 <\/td>\n<\/tr>\n
62<\/td>\n10.15 <\/td>\n<\/tr>\n
63<\/td>\n10.16 <\/td>\n<\/tr>\n
64<\/td>\n10.17 <\/td>\n<\/tr>\n
65<\/td>\n10.18 <\/td>\n<\/tr>\n
66<\/td>\n10.19 <\/td>\n<\/tr>\n
67<\/td>\n10.20 <\/td>\n<\/tr>\n
68<\/td>\n10.21 <\/td>\n<\/tr>\n
71<\/td>\n10.22 <\/td>\n<\/tr>\n
72<\/td>\n10.23 <\/td>\n<\/tr>\n
73<\/td>\n10.24 <\/td>\n<\/tr>\n
75<\/td>\n10.25 <\/td>\n<\/tr>\n
76<\/td>\n10.26 <\/td>\n<\/tr>\n
77<\/td>\n11 Access control
11.1 <\/td>\n<\/tr>\n
78<\/td>\n11.2 <\/td>\n<\/tr>\n
79<\/td>\n11.3 <\/td>\n<\/tr>\n
83<\/td>\n12 SQL-client modules
12.1 <\/td>\n<\/tr>\n
85<\/td>\n12.2 <\/td>\n<\/tr>\n
86<\/td>\n13 Data manipulation
13.1 <\/td>\n<\/tr>\n
87<\/td>\n13.2 <\/td>\n<\/tr>\n
88<\/td>\n13.3 <\/td>\n<\/tr>\n
89<\/td>\n13.4 <\/td>\n<\/tr>\n
90<\/td>\n13.5 <\/td>\n<\/tr>\n
91<\/td>\n13.6 <\/td>\n<\/tr>\n
92<\/td>\n13.7 <\/td>\n<\/tr>\n
93<\/td>\n13.8 <\/td>\n<\/tr>\n
94<\/td>\n14 Additional data manipulation rules
14.1 Effect of opening a cursor <\/td>\n<\/tr>\n
95<\/td>\n15 Control statements
15.1 <\/td>\n<\/tr>\n
99<\/td>\n15.2 <\/td>\n<\/tr>\n
101<\/td>\n15.3 <\/td>\n<\/tr>\n
102<\/td>\n15.4 <\/td>\n<\/tr>\n
103<\/td>\n15.5 <\/td>\n<\/tr>\n
107<\/td>\n15.6 <\/td>\n<\/tr>\n
110<\/td>\n15.7 <\/td>\n<\/tr>\n
112<\/td>\n15.8 <\/td>\n<\/tr>\n
113<\/td>\n15.9 <\/td>\n<\/tr>\n
114<\/td>\n15.10 <\/td>\n<\/tr>\n
115<\/td>\n15.11 <\/td>\n<\/tr>\n
117<\/td>\n15.12 <\/td>\n<\/tr>\n
118<\/td>\n15.13 <\/td>\n<\/tr>\n
121<\/td>\n16 Dynamic SQL
16.1 <\/td>\n<\/tr>\n
123<\/td>\n16.2 <\/td>\n<\/tr>\n
124<\/td>\n16.3 <\/td>\n<\/tr>\n
125<\/td>\n17 Embedded SQL
17.1 <\/td>\n<\/tr>\n
127<\/td>\n18 Diagnostics management
18.1 <\/td>\n<\/tr>\n
129<\/td>\n18.2 <\/td>\n<\/tr>\n
131<\/td>\n18.3 <\/td>\n<\/tr>\n
133<\/td>\n19 Information Schema
19.1 Information Schema digital artifact
19.2 MODULE_COLUMN_USAGE view <\/td>\n<\/tr>\n
135<\/td>\n19.3 MODULE_PRIVILEGES view <\/td>\n<\/tr>\n
136<\/td>\n19.4 MODULE_TABLE_USAGE view <\/td>\n<\/tr>\n
137<\/td>\n19.5 MODULES view <\/td>\n<\/tr>\n
138<\/td>\n19.6 PARAMETERS view <\/td>\n<\/tr>\n
139<\/td>\n19.7 ROLE_MODULE_GRANTS view <\/td>\n<\/tr>\n
140<\/td>\n19.8 ROUTINES view <\/td>\n<\/tr>\n
141<\/td>\n19.9 Short name views <\/td>\n<\/tr>\n
142<\/td>\n20 Definition Schema
20.1 Definition Schema digital artifact
20.2 MODULE_COLUMN_USAGE base table <\/td>\n<\/tr>\n
144<\/td>\n20.3 MODULE_PRIVILEGES base table <\/td>\n<\/tr>\n
146<\/td>\n20.4 MODULE_TABLE_USAGE base table <\/td>\n<\/tr>\n
147<\/td>\n20.5 MODULES base table <\/td>\n<\/tr>\n
149<\/td>\n20.6 ROUTINES base table <\/td>\n<\/tr>\n
150<\/td>\n21 Status codes
21.1 SQLSTATE <\/td>\n<\/tr>\n
151<\/td>\n22 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 <\/td>\n<\/tr>\n
153<\/td>\n22.4 Syntactic transformations applied before Conformance Rules in SQL\/PSM <\/td>\n<\/tr>\n
154<\/td>\nA SQL Conformance Summary <\/td>\n<\/tr>\n
159<\/td>\nB Implementation-defined elements <\/td>\n<\/tr>\n
161<\/td>\nC Implementation-dependent elements <\/td>\n<\/tr>\n
163<\/td>\nD SQL optional feature taxonomy <\/td>\n<\/tr>\n
165<\/td>\nE Deprecated features <\/td>\n<\/tr>\n
166<\/td>\nF Incompatibilities with ISO\/IEC 9075:2011 <\/td>\n<\/tr>\n
167<\/td>\nG Defect reports not addressed in this edition of this document <\/td>\n<\/tr>\n
168<\/td>\nBibliography <\/td>\n<\/tr>\n
169<\/td>\nIndex <\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

BS ISO\/IEC 9075-4. Information technology. Database languages. SQL – Part 4. Persistent stored modules (SQL\/PSM)<\/b><\/p>\n\n\n\n\n
Published By<\/td>\nPublication Date<\/td>\nNumber of Pages<\/td>\n<\/tr>\n
BSI<\/b><\/a><\/td>\n2022<\/td>\n172<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"featured_media":409621,"template":"","meta":{"rank_math_lock_modified_date":false,"ep_exclude_from_search":false},"product_cat":[2641],"product_tag":[],"class_list":{"0":"post-409613","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-bsi","8":"first","9":"instock","10":"sold-individually","11":"shipping-taxable","12":"purchasable","13":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product\/409613","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media\/409621"}],"wp:attachment":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media?parent=409613"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_cat?post=409613"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_tag?post=409613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}