17.10 - Example: Generating a Report of BYNET Events Between December and January - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Publication ID
B035-1103-171K
Language
English (United States)

The following statement generates a report of BYNET Events between December 19, 2012 and January 1, 2013:

Exec BynetEvents ('2012-12-19', '2013-01-01');

The resulting report follows:

Exec BynetEvents ('2012-12-19','2013-01-01');

*** Echo accepted.
*** Total elapsed time was 1 second.

*** Echo accepted.
*** Echo accepted.
*** Echo accepted.
*** Echo accepted.
*** Echo accepted.
*** Echo accepted.
*** Echo accepted.
*** Echo accepted.
*** Query completed. 9 rows found. 5 columns returned.
13/02/29      BYNET Events Between 12/12/19 and 13/01/01      16:19
Date                 Time Message Text
-------- ---------------- -------------------------------------------------
12/12/28  12:49:04.000000 140001006|bynet |1|S|I|O|1|1|B|0|0|bya.c|65535|65535|
                          65535|10#BYA: BYA113-4 restarting to bring in late
                          arriver node 0xDE4 on port 0.
              
          14:52:48.000000 140000806|bynet|1|H|I|O|1|2|B|0|0|bya.c|65535|65535|
                          65535|11#BYA: BYA112-4 input port error on
                          adapter port 1: unexpected command.
                          140000806|bynet|1|H|I|O|1|2|B|0|0|bya.c|65535|65535|
                          65535|11#BYA: BYA113-4 input port error on adapter
                          port 0: soft carrier loss.
          15:02:05.000000 140001006|bynet |1|S|I|O|1|2|B|0|0|bya.c|65535|65535|
                          65535|12#BYA: BYA113-4 restarting to bring in late
                          arriver node 0xDE4 on port 0.
                          140001006|bynet |1|S|I|O|1|3|B|0|0|bya.c|65535|65535|
                          65535|12#BYA: BYA112-4 restarting to bring in late
                          arriver node 0xDE4 on port 1.
12/12/29  19:09:48.000000 140000806|bynet |1|H|I|O|1|3|B|0|0|bya.c|65535|65535|
                          65535|13#BYA: BYA113-4 input port error on adapter
                          port 0: soft carrier loss.
                          140000806|bynet |1|H|I|O|1|2|B|0|0|bya.c|65535|65535|
                          65535|13#BYA: BYA112-4 input port error on adapter
                          port 1: violation error.
          19:19:06.000000 140001006|bynet |1|S|I|O|1|1|B|0|0|bya.c|65535|65535|
                          65535|14#BYA: BYA112-4 restarting to bring in late
                          arriver node 0xDE4 on port 1.
                          140001006|bynet |1|S|I|O|1|3|B|0|0|bya.c|65535|65535|
                          65535|14#BYA: BYA113-4 restarting to bring in late
                          arriver node 0xDE4 on port 0.
*** Echo accepted.