Example: Dynamic Row Results Returned by Specifying Table Functions - Teradata Database - Teradata Vantage NewSQL Engine

SQL Data Manipulation Language

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
fbo1512081269404.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™

The following example uses the extract_store_data table function to return dynamic row results in the store_data table:

     SELECT *
     FROM (TABLE(extract_store_data('…', 1000) 
     RETURNS store_data) AS store_sales;

The following equivalent examples use the sales_retrieve table function to return dynamic row results either by specifying the maximum number of output columns and their individual column names and data types or by specifying only the name of the table into which the converted rows are to be written.

     SELECT *
     FROM TABLE (sales_retrieve(9005)
     RETURNS (store    INTEGER, 
              item     INTEGER,
              quantity INTEGER)) AS s;

     SELECT *
     FROM TABLE (sales_retrieve(9005)
     RETURNS sales_table) AS s;