ISO/IEC TR 19075-7:2017
Information technology — Database languages — SQL Technical Reports — Part 7: Polymorphic table functions in SQL
ISO/IEC TR 19075-7:2017 describes the definition and use of polymorphic table functions in SQL.
ISO/IEC TR 19075-7:2017 discusses the following features of the SQL Language:
- The processing model of polymorphic table functions in the context of SQL.
- The creation and maintenance of polymorphic table functions.
- Issues related to methods of implementing polymorphic table functions.
- How polymorphic table functions are invoked by application programs.
- Issues concerning compilation, optimization, and execution of polymorphic table functions.
| Get this standard | Prices exclude GST | |
|---|---|---|
| PDF ( Single user document) |
$118.26 NZD
|
|
| HardCopy |
$152.17 NZD
|
|
| Networkable PDF |
Price varies
|
Contents
Tables
Figures
Foreword
Introduction
1 Scope
2 Normative references
2.1 ISO and IEC standards
3 Introduction to Polymorphic Table Functions
3.1 Audiences
3.2 Motivating examples
3.2.1 CSVreader
3.2.2 Pivot
3.2.3 Score
3.2.4 TopNplus
3.2.5 ExecR
3.2.6 Similarity
3.2.7 UDjoin
3.2.8 MapReduce
3.3 The life cycle of a PTF
4 PTF processing model
4.1 Processing phases
4.2 Virtual processors
4.3 PTF component procedures
4.4 Input table characteristics
4.5 Partitioning and ordering
4.6 Flow of control
4.7 Flow of information
4.8 Flow of row types
4.9 Pass-through columns
4.10 Security model
4.11 Conformance features
5 Specification
5.1 Functional specification
5.1.1 Parameter list
5.1.2 Input table semantics
5.1.3 Prunability
5.1.4 Pass-through columns
5.1.5 Result row type
5.1.6 Determinism
5.1.7 SQL-data access
5.1.8 Documenting the PTF to the query author
5.2 Design specification
5.2.1 Name the component procedures
5.2.2 Private data
5.2.3 Routine characteristics of the component procedures
5.2.4 Component procedure signatures
6 Data definition language
6.1 PTF creation
6.2 PTF component procedures
6.3 Altering PTF component procedures and PTFs
6.4 Dropping a PTF and its component procedures
7 Implementation
7.1 PTF descriptor areas
7.1.1 PTF descriptor area header
7.1.2 SQL item descriptor areas for row types
7.1.3 SQL item descriptor areas for partitioning
7.1.4 SQL item descriptor areas for ordering
7.2 PTF extended names
7.3 Reading a PTF descriptor area
7.4 Writing a PTF descriptor area
7.4.1 Using DESCRIBE to populate a PTF descriptor area
7.4.2 Using SET DESCRIPTOR to populate a PTF descriptor area
7.4.3 Using COPY DESCRIPTOR to populate a PTF descriptor area
7.5 Reading a PTF input cursor
7.6 Outputting a row
8 Invocation
8.1
Keep me up-to-date
Sign up to receive updates when there are changes to this standard
Related Information
Similar Standards
-
AS/NZS 3968.0:1994
Information technology - Database languages - SQL - Definition of data structures and basic operations
-
AS/NZS 3968.0:1994 A1
Information technology - Database languages - SQL - Definition of data structures and basic operations: Amendment 1
-
AS/NZS 3968.3:1998
Information technology - Database languages - SQL - Call-level interface
-
AS/NZS ISO/IEC 14882:2022
Programming languages – C++
Contents
Tables
Figures
Foreword
Introduction
1 Scope
2 Normative references
2.1 ISO and IEC standards
3 Introduction to Polymorphic Table Functions
3.1 Audiences
3.2 Motivating examples
3.2.1 CSVreader
3.2.2 Pivot
3.2.3 Score
3.2.4 TopNplus
3.2.5 ExecR
3.2.6 Similarity
3.2.7 UDjoin
3.2.8 MapReduce
3.3 The life cycle of a PTF
4 PTF processing model
4.1 Processing phases
4.2 Virtual processors
4.3 PTF component procedures
4.4 Input table characteristics
4.5 Partitioning and ordering
4.6 Flow of control
4.7 Flow of information
4.8 Flow of row types
4.9 Pass-through columns
4.10 Security model
4.11 Conformance features
5 Specification
5.1 Functional specification
5.1.1 Parameter list
5.1.2 Input table semantics
5.1.3 Prunability
5.1.4 Pass-through columns
5.1.5 Result row type
5.1.6 Determinism
5.1.7 SQL-data access
5.1.8 Documenting the PTF to the query author
5.2 Design specification
5.2.1 Name the component procedures
5.2.2 Private data
5.2.3 Routine characteristics of the component procedures
5.2.4 Component procedure signatures
6 Data definition language
6.1 PTF creation
6.2 PTF component procedures
6.3 Altering PTF component procedures and PTFs
6.4 Dropping a PTF and its component procedures
7 Implementation
7.1 PTF descriptor areas
7.1.1 PTF descriptor area header
7.1.2 SQL item descriptor areas for row types
7.1.3 SQL item descriptor areas for partitioning
7.1.4 SQL item descriptor areas for ordering
7.2 PTF extended names
7.3 Reading a PTF descriptor area
7.4 Writing a PTF descriptor area
7.4.1 Using DESCRIBE to populate a PTF descriptor area
7.4.2 Using SET DESCRIPTOR to populate a PTF descriptor area
7.4.3 Using COPY DESCRIPTOR to populate a PTF descriptor area
7.5 Reading a PTF input cursor
7.6 Outputting a row
8 Invocation
8.1