Importance of Specifying Default Values in Commands | Basic Teradata Query - Specifying Default Values - Basic Teradata Query

Basic Teradata® Query Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-04-02
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
Product Category
Teradata Tools and Utilities

When specifying the default option for a command within a script or a macro, always specify the default value explicitly. Specifying command options explicitly helps clarify what the script or macro does if a problem arises, or if editing is needed.

If the defaults for a command change, having the options specified explicitly also removes the task of updating scripts or macros that use the command.

The command-specific HELP will state what assumed default values exist when the SET commands are used without specifying arguments.