{"id":353117,"date":"2024-10-20T00:56:15","date_gmt":"2024-10-20T00:56:15","guid":{"rendered":"https:\/\/pdfstandards.shop\/product\/uncategorized\/bs-iso-iec-9075-152019\/"},"modified":"2024-10-26T01:01:21","modified_gmt":"2024-10-26T01:01:21","slug":"bs-iso-iec-9075-152019","status":"publish","type":"product","link":"https:\/\/pdfstandards.shop\/product\/publishers\/bsi\/bs-iso-iec-9075-152019\/","title":{"rendered":"BS ISO\/IEC 9075-15:2019"},"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\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
PDF Pages<\/th>\nPDF Title<\/th>\n<\/tr>\n
2<\/td>\nNational foreword <\/td>\n<\/tr>\n
5<\/td>\nContents <\/td>\n<\/tr>\n
9<\/td>\nTables <\/td>\n<\/tr>\n
11<\/td>\nForeword <\/td>\n<\/tr>\n
12<\/td>\nIntroduction <\/td>\n<\/tr>\n
15<\/td>\n1 Scope <\/td>\n<\/tr>\n
17<\/td>\n2 Normative references <\/td>\n<\/tr>\n
19<\/td>\n3 Terms and definitions
3.1 Definitions
3.1.1 Definitions provided in this document <\/td>\n<\/tr>\n
21<\/td>\n4 Concepts
4.1 SQL data types
4.1.1 SQL data types
4.1.1.1 Collection types
4.2 SQL-schema objects
4.2.1 User-defined types
4.2.1.1 Distinct types <\/td>\n<\/tr>\n
23<\/td>\n5 The parts of ISO\/IEC 9075
5.1 Overview
5.2 ISO\/IEC 9075-15: MultiDimensional Arrays (SQL\/MDA) <\/td>\n<\/tr>\n
25<\/td>\n6 Concepts
6.1 Data types
6.1.1 General introduction to data types
6.1.2 Data type terminology
6.2 Numbers <\/td>\n<\/tr>\n
26<\/td>\n6.2.1 Operations involving numbers
6.3 User-defined types
6.3.1 Distinct types
6.4 Collection types
6.4.1 Introduction to collection types <\/td>\n<\/tr>\n
27<\/td>\n6.4.2 MD-arrays <\/td>\n<\/tr>\n
28<\/td>\n6.4.3 Collection comparison and assignment
6.4.4 Operations involving MD-arrays
6.4.4.1 Operators that operate on MD-array values and return MD-array values <\/td>\n<\/tr>\n
30<\/td>\n6.4.4.2 Operators that operate on MD-array values and return tables
6.4.4.3 Operators that operate on MD-array values and return numbers
6.4.4.4 Operators that operate on MD-array values and return character strings <\/td>\n<\/tr>\n
31<\/td>\n6.4.4.5 Operators that operate on MD-array values and return numbers or Boolean values
6.4.4.6 Operators that operate on MD-array values and return character or binary strings
6.4.4.7 Operators that construct new MD-array values <\/td>\n<\/tr>\n
32<\/td>\n6.4.4.8 Operators that operate on MD-array values and return MD-array elements
6.4.5 MD-axis variables <\/td>\n<\/tr>\n
33<\/td>\n7 Lexical elements
7.1 <token> and <separator> <\/td>\n<\/tr>\n
34<\/td>\n7.2 Names and identifiers <\/td>\n<\/tr>\n
35<\/td>\n8 Scalar expressions
8.1 <data type> <\/td>\n<\/tr>\n
38<\/td>\n8.2 <value expression primary> <\/td>\n<\/tr>\n
40<\/td>\n8.3 <md-array subset> <\/td>\n<\/tr>\n
43<\/td>\n8.4 <identifier chain> <\/td>\n<\/tr>\n
44<\/td>\n8.5 <md-array aggregation expression> <\/td>\n<\/tr>\n
47<\/td>\n8.6 <case expression> <\/td>\n<\/tr>\n
49<\/td>\n8.7 <cast specification> <\/td>\n<\/tr>\n
52<\/td>\n8.8 <numeric value function> <\/td>\n<\/tr>\n
55<\/td>\n8.9 <string value function> <\/td>\n<\/tr>\n
57<\/td>\n8.10 <md-array encode function> <\/td>\n<\/tr>\n
59<\/td>\n8.11 <value expression> <\/td>\n<\/tr>\n
60<\/td>\n8.12 <md-array value expression> <\/td>\n<\/tr>\n
66<\/td>\n8.13 <md-array value function> <\/td>\n<\/tr>\n
74<\/td>\n8.14 <md-array value constructor> <\/td>\n<\/tr>\n
80<\/td>\n8.15 <md-array element reference> <\/td>\n<\/tr>\n
83<\/td>\n9 Query expressions
9.1 <table reference> <\/td>\n<\/tr>\n
87<\/td>\n9.2 <query specification> <\/td>\n<\/tr>\n
89<\/td>\n10 Predicates
10.1 <distinct predicate> <\/td>\n<\/tr>\n
91<\/td>\n11 Additional common rules
11.1 Retrieval assignment <\/td>\n<\/tr>\n
93<\/td>\n11.2 Store assignment <\/td>\n<\/tr>\n
94<\/td>\n11.3 Passing a value from a host language to the SQL-server <\/td>\n<\/tr>\n
95<\/td>\n11.4 Passing a value from the SQL-server to a host language <\/td>\n<\/tr>\n
96<\/td>\n11.5 Result of data type combinations <\/td>\n<\/tr>\n
97<\/td>\n11.6 Type precedence list determination <\/td>\n<\/tr>\n
98<\/td>\n11.7 Type name determination <\/td>\n<\/tr>\n
99<\/td>\n11.8 Determination of identical values <\/td>\n<\/tr>\n
100<\/td>\n11.9 Equality operations <\/td>\n<\/tr>\n
101<\/td>\n11.10 Grouping operations <\/td>\n<\/tr>\n
102<\/td>\n11.11 Multiset element grouping operations <\/td>\n<\/tr>\n
103<\/td>\n11.12 Ordering operations <\/td>\n<\/tr>\n
104<\/td>\n11.13 Data type identity <\/td>\n<\/tr>\n
105<\/td>\n11.14 Indexed name <\/td>\n<\/tr>\n
106<\/td>\n11.15 MD-array subset <\/td>\n<\/tr>\n
110<\/td>\n11.16 Canonicalize MD-array element reference <\/td>\n<\/tr>\n
112<\/td>\n11.17 Execution of MD-array-returning functions <\/td>\n<\/tr>\n
115<\/td>\n12 Additional common elements
12.1 <routine invocation> <\/td>\n<\/tr>\n
117<\/td>\n12.2 <md-extent alternative> <\/td>\n<\/tr>\n
119<\/td>\n12.3 <md-array md-axis> <\/td>\n<\/tr>\n
121<\/td>\n13 Schema definition and manipulation
13.1 <column definition> <\/td>\n<\/tr>\n
122<\/td>\n13.2 <view definition> <\/td>\n<\/tr>\n
123<\/td>\n13.3 <user-defined type definition> <\/td>\n<\/tr>\n
124<\/td>\n13.4 <SQL-invoked routine> <\/td>\n<\/tr>\n
125<\/td>\n14 SQL-client modules
14.1 <externally-invoked procedure> <\/td>\n<\/tr>\n
127<\/td>\n14.2 Data type correspondences <\/td>\n<\/tr>\n
129<\/td>\n15 Data manipulation
15.1 <set clause list> <\/td>\n<\/tr>\n
133<\/td>\n16 Dynamic SQL
16.1 Description of SQL descriptor areas <\/td>\n<\/tr>\n
135<\/td>\n16.2 <get descriptor statement> <\/td>\n<\/tr>\n
136<\/td>\n16.3 <describe statement> <\/td>\n<\/tr>\n
137<\/td>\n17 Embedded SQL
17.1 <embedded SQL Ada program> <\/td>\n<\/tr>\n
139<\/td>\n17.2 <embedded SQL C program> <\/td>\n<\/tr>\n
140<\/td>\n17.3 <embedded SQL COBOL program> <\/td>\n<\/tr>\n
141<\/td>\n17.4 <embedded SQL Fortran program> <\/td>\n<\/tr>\n
142<\/td>\n17.5 <embedded SQL MUMPS program> <\/td>\n<\/tr>\n
143<\/td>\n17.6 <embedded SQL PL\/I program> <\/td>\n<\/tr>\n
145<\/td>\n18 Call-Level Interface specifications
18.1 SQL\/CLI data type correspondences <\/td>\n<\/tr>\n
147<\/td>\n19 Information Schema
19.1 ELEMENT_TYPES view <\/td>\n<\/tr>\n
148<\/td>\n19.2 MD_EXTENTS view <\/td>\n<\/tr>\n
149<\/td>\n20 Definition Schema
20.1 DATA_TYPE_DESCRIPTOR base table <\/td>\n<\/tr>\n
150<\/td>\n20.2 ELEMENT_TYPES base table <\/td>\n<\/tr>\n
151<\/td>\n20.3 MD_EXTENTS base table <\/td>\n<\/tr>\n
153<\/td>\n20.4 SQL_CONFORMANCE base table <\/td>\n<\/tr>\n
155<\/td>\n21 Status codes
21.1 SQLSTATE <\/td>\n<\/tr>\n
157<\/td>\n22 Conformance
22.1 Claims of conformance to SQL\/MDA
22.2 Implied feature relationships of SQL\/MDA <\/td>\n<\/tr>\n
159<\/td>\nA SQL Conformance Summary <\/td>\n<\/tr>\n
165<\/td>\nB Implementation-defined elements <\/td>\n<\/tr>\n
167<\/td>\nC Implementation-dependent elements <\/td>\n<\/tr>\n
169<\/td>\nD Incompatibilities with ISO\/IEC 9075:2011 <\/td>\n<\/tr>\n
171<\/td>\nE SQL feature taxonomy <\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Information technology. Database languages. SQL – Multi-dimensional arrays (SQL\/MDA)<\/b><\/p>\n\n\n\n\n
Published By<\/td>\nPublication Date<\/td>\nNumber of Pages<\/td>\n<\/tr>\n
BSI<\/b><\/a><\/td>\n2019<\/td>\n178<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"featured_media":353124,"template":"","meta":{"rank_math_lock_modified_date":false,"ep_exclude_from_search":false},"product_cat":[2641],"product_tag":[],"class_list":{"0":"post-353117","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\/353117","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\/353124"}],"wp:attachment":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media?parent=353117"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_cat?post=353117"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_tag?post=353117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}