🔥🔥 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.

🔍
BS ISO/IEC 9075-15:2019

BS ISO/IEC 9075-15:2019

$215.11

Information technology. Database languages. SQL – Multi-dimensional arrays (SQL/MDA)

Published By Publication Date Number of Pages
BSI 2019 178
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
2 National foreword
5 Contents
9 Tables
11 Foreword
12 Introduction
15 1 Scope
17 2 Normative references
19 3 Terms and definitions
3.1 Definitions
3.1.1 Definitions provided in this document
21 4 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
23 5 The parts of ISO/IEC 9075
5.1 Overview
5.2 ISO/IEC 9075-15: MultiDimensional Arrays (SQL/MDA)
25 6 Concepts
6.1 Data types
6.1.1 General introduction to data types
6.1.2 Data type terminology
6.2 Numbers
26 6.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
27 6.4.2 MD-arrays
28 6.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
30 6.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
31 6.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
32 6.4.4.8 Operators that operate on MD-array values and return MD-array elements
6.4.5 MD-axis variables
33 7 Lexical elements
7.1 <token> and <separator>
34 7.2 Names and identifiers
35 8 Scalar expressions
8.1 <data type>
38 8.2 <value expression primary>
40 8.3 <md-array subset>
43 8.4 <identifier chain>
44 8.5 <md-array aggregation expression>
47 8.6 <case expression>
49 8.7 <cast specification>
52 8.8 <numeric value function>
55 8.9 <string value function>
57 8.10 <md-array encode function>
59 8.11 <value expression>
60 8.12 <md-array value expression>
66 8.13 <md-array value function>
74 8.14 <md-array value constructor>
80 8.15 <md-array element reference>
83 9 Query expressions
9.1 <table reference>
87 9.2 <query specification>
89 10 Predicates
10.1 <distinct predicate>
91 11 Additional common rules
11.1 Retrieval assignment
93 11.2 Store assignment
94 11.3 Passing a value from a host language to the SQL-server
95 11.4 Passing a value from the SQL-server to a host language
96 11.5 Result of data type combinations
97 11.6 Type precedence list determination
98 11.7 Type name determination
99 11.8 Determination of identical values
100 11.9 Equality operations
101 11.10 Grouping operations
102 11.11 Multiset element grouping operations
103 11.12 Ordering operations
104 11.13 Data type identity
105 11.14 Indexed name
106 11.15 MD-array subset
110 11.16 Canonicalize MD-array element reference
112 11.17 Execution of MD-array-returning functions
115 12 Additional common elements
12.1 <routine invocation>
117 12.2 <md-extent alternative>
119 12.3 <md-array md-axis>
121 13 Schema definition and manipulation
13.1 <column definition>
122 13.2 <view definition>
123 13.3 <user-defined type definition>
124 13.4 <SQL-invoked routine>
125 14 SQL-client modules
14.1 <externally-invoked procedure>
127 14.2 Data type correspondences
129 15 Data manipulation
15.1 <set clause list>
133 16 Dynamic SQL
16.1 Description of SQL descriptor areas
135 16.2 <get descriptor statement>
136 16.3 <describe statement>
137 17 Embedded SQL
17.1 <embedded SQL Ada program>
139 17.2 <embedded SQL C program>
140 17.3 <embedded SQL COBOL program>
141 17.4 <embedded SQL Fortran program>
142 17.5 <embedded SQL MUMPS program>
143 17.6 <embedded SQL PL/I program>
145 18 Call-Level Interface specifications
18.1 SQL/CLI data type correspondences
147 19 Information Schema
19.1 ELEMENT_TYPES view
148 19.2 MD_EXTENTS view
149 20 Definition Schema
20.1 DATA_TYPE_DESCRIPTOR base table
150 20.2 ELEMENT_TYPES base table
151 20.3 MD_EXTENTS base table
153 20.4 SQL_CONFORMANCE base table
155 21 Status codes
21.1 SQLSTATE
157 22 Conformance
22.1 Claims of conformance to SQL/MDA
22.2 Implied feature relationships of SQL/MDA
159 A SQL Conformance Summary
165 B Implementation-defined elements
167 C Implementation-dependent elements
169 D Incompatibilities with ISO/IEC 9075:2011
171 E SQL feature taxonomy

Related products

BS ISO/IEC 9075-15:2019
$215.11