Example: Generating a Report of Tables Without the Fallback Option - Advanced SQL Engine - Teradata Database

SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynt1557098768177.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1103
lifecycle
previous
Product Category
Teradata Vantage™

The following statement generates a report of all tables without the fallback option:

Exec NoFallBack_All;

The resulting report follows:

                   Exec NoFallBack_All;

*** Query completed. 20 rows found. 3 columns returned.
13/05/21                 NoFallBack Tables In All Databases                09:36
DataBase         Table                                         Bytes
---------------  ------------------------------  -------------------
DBC              Acctg                                         7,680
                 ChangedRowJournal                             2,048
                 DataBaseSpace                               104,448
                 LocalSessionStatusTable                       6,144
                 LocalTransactionStatusTable                   2,048
                 OrdSysChngTable                               2,048
                 ReconfigJournal                               2,048
                 RecoveryLockTable                             2,048
                 RecoveryPJTable                               2,048
                 SavedTransactionStatusTable                   2,048
                 SysRcvStatJournal                            25,088
                 TransientJournal                         15,859,712
                 UtilityLockJournalTable                       2,048
 *** Echo accepted.