17.10 - Example Output - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)
SELECT * FROM table (phase (t.v, 'mike')) AS d
; SELECT * FROM udftrace ORDER BY 1,2;

*** 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