Examples - Teradata Vantage - Analytics Database

SystemFE Macros

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
iqw1628112378327.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
usl1472251351342
lifecycle
latest
Product Category
Teradata Vantageā„¢

The following example returns the percent value for macros CDS_Database, CDS_Database_ANSI, CDS_System, and CDS_System_ANSI to use when collecting statistics:

EXEC systemfe.CDS_ViewPercentData;
 *** Query completed. One row found. One column returned. 
 *** Total elapsed time was 1 second.

PercentValue
------------
       80.00