Example Output - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
Product Category
Teradata Vantage™
SELECT * FROM table (phase (t.v, 'mike')) AS d
; SELECT * FROM udftrace ORDER BY 1,2;

Result:

*** Query completed. 10 rows found. 2 columns returned.
*** Total elapsed time was 1 second.

         o1 o2
----------- -----------------------------------------------------
          5 mike
          9 mike
          7 mike
          6 mike
          3 mike
          10 mike
          1 mike
          4 mike
          8 mike
          2 mike

*** Query completed. 52 rows found. 3 columns returned.

Amp_number    Sequence Message
---------- ----------- ------------------------------------------
0000                 1   In Pre Init
0000                 2   In Init
0000                 3   In Build, input 1 is 5
0000                 4   In Build setting EOF, input 1 is 5
0000                 5   In Fini
0000                 6   In Init
0000                 7   In Build, input 1 is 1
0000                 8   In Build setting EOF, input 1 is 1
0000                 9   In Fini
0000                10   In Init
0000                11   In Build, input 1 is 8
0000                12   In Build setting EOF, input 1 is 8
0000                13   In Fini
0000                14   In Init
0000                15   In Build, input 1 is 2
0000                16   In Build setting EOF, input 1 is 2
0000                17   In Fini
0000                18   In END
0100                 1   In Pre Init
0100                 2   In Init
0100                 3   In Build, input 1 is 9
0100                 4   In Build setting EOF, input 1 is 9
0100                 5   In Fini
0100                 6   In END
0200                 1   In Pre Init
0200                 2   In Init
0200                 3   In Build, input 1 is 7
0200                 4   In Build setting EOF, input 1 is 7
0200                 5   In Fini
0200                 6   In Init
0200                 7   In Build, input 1 is 4
0200                 8   In Build setting EOF, input 1 is 4
0200                 9   In Fini
0200                10   In END
0500                 1   In Pre Init
0500                 2   In Init
0500                 3   In Build, input 1 is 6
0500                 4   In Build setting EOF, input 1 is 6
0500                 5   In Fini
0500                 6   In END
0600                 1   In Pre Init
0600                 2   In Init
0600                 3   In Build, input 1 is 3
0600                 4   In Build setting EOF, input 1 is 3
0600                 5   In Fini
0600                 6   In END
0700                 1   In Pre Init
0700                 2   In Init
0700                 3   In Build, input 1 is 10
0700                 4   In Build setting EOF, input 1 is 10
0700                 5   In Fini
0700                 6   In END