DEFAULTS - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose  

Resets the following types of BTEQ command settings to the original value they had when BTEQ was first invoked:

  • Settings related to report mode output format.
  • Settings related to response data format.
  • Settings related to import process message verbosity.
  • Settings related to specifying SQL request retries.
  • Syntax  

    Usage Notes  

    The DEFAULTS command does not reset all BTEQ command settings. It only resets those deemed most likely to get used as part of large group of commands issued collectively to establish a particular desired combination state. Rather than having to reissue each command again to undo the settings established, BTEQ provides the DEFAULTS command as a simpler way to accomplish what could typically be the same end result using just one command. To be certain DEFAULTS command use has had the desired effect, the SHOW CONTROLS command can be used to display a specific setting's current value or the following table, which lists the commands which will get their setting state reset, can be referred to.

    The EXPORT command settings are not completely reset because an active export is not deactivated. However, an active export's option state is significantly altered by use of the DEFAULTS command. As a result of the default response being reset back to field mode, an active export's data format option will be changed to REPORT and if a NOEJECT option was used from it, that will be changed to EJECT.

    BTEQ commands:

     

    Resetting Defaults by Logging Off

    The LOGON and LOGOFF commands do not alter format settings. Use the DEFAULTS command to reset format settings to their initial defaults.

    The only times that the format commands are the default values listed above are when the first LOGON command is executed after invoking BTEQ, and when the DEFAULTS command is used.

    The following list shows the initial default condition of BTEQ at the first LOGON. When the DEFAULTS command is used, it resets these formats to the initial default value.

    show controls ;
     Default Maximum Byte Count          = 1048500
     Default Multiple Maximum Byte Count = 2048
     Current Response Byte Count         = 32705
     Maximum number of sessions          = 200
     Maximum request size                = 32705
     Maximum IMPORT/USING data size      = 32705
     Maximum number of returnable columns= 2048
     Maximum number of WITH clauses      = 10
     Maximum number of times in a REPEAT = 2147483647
     Maximum number of script files      = 30
     Maximum number of lines in a TITLE  = 10
     Maximum number of lines per page    = 2147483647
     Maximum string length               = 254
     Maximum number of WIDTH in a report = 65531
     Minimum number of WIDTH in a report = 20
     
     Maximum Notify MSG text Byte Count  = 254
     Maximum number of bytes saved for
     SUPPRESS, PAGEBREAK, SKIPLINE,
     UNDERLINE, or SKIPDOUBLE commands,
     or for &n substitutions             = 256
     
     Client Platform Byte Order          = LITTLE ENDIAN
     
     EXPORT  RESET
     IMPORT FIELD
     LOGMECH                 = default
     LOGON 
     REPEAT                  = 1
     RUN
     [SET] AUTOKEYRETRIEVE   = OFF
     [SET] DECIMALDIGITS     = 0 (SPB DEFAULT)
     [SET] ECHOREQ           = ON
     [SET] ENCRYPTION = OFF
     [SET] ERRORLEVEL        = ON
     [SET] FOLDLINE          = OFF ALL
     [SET] FOOTING           = NULL
     [SET] FORMAT            = OFF
     [SET] FORMCHAR          = OFF
     [SET] FULLYEAR          = OFF
     [SET] HEADING           = NULL
     
     [SET] INDICATORMODE = OFF
     [SET] LARGEDATAMODE     = OFF
     [SET] LOGONPROMPT = ON
     
     [SET] NOTIFY            = OFF
     [SET] NULL              = ?
     [SET] OMIT              = OFF ALL
     [SET] PACK = 0
     [SET] PAGEBREAK         = OFF ALL
     [SET] PAGELENGTH        = 55
     [SET] PREPAREMODE = OFF
     [SET] QUIET             = OFF
     [SET] RECORDMODE        = OFF
     [SET] REPEATSTOP        = OFF
     [SET] REPORTALIGN       = COMPATIBLE
     [SET] RETCANCEL         = OFF
     [SET] RETLIMIT          = Rows: No Limit  Columns: 100
     [SET] RETRY             = ON
     [SET] RTITLE            = NULL
     [SET] SEPARATOR         = two blanks
     
     [SET] SESSION CHARSET = ASCII
           import/export encoding = ASCII
           stdin/stdout encoding  = ASCII
     [SET] SESSION RESPBUFLEN  = 8192
     [SET] SESSION SQLFLAG   = NONE
     [SET] SESSION TRANSACTION = Unknown
     [SET] SESSION TWORESPBUFS = ON
     [SET] SESSIONS          = 1
     [SET] SIDETITLES        = OFF for the normal report.
           And, it is   ON for results of WITH clause number: 1 2 3 4 5 6 7 8 9.
     [SET] SKIPDOUBLE        = OFF ALL
     [SET] SKIPLINE          = OFF ALL
     [SET] SUPPRESS          = OFF ALL
     [SET] TDP               = dbc
     [SET] TIMEMSG           = DEFAULT
     [SET] TITLEDASHES       = ON for the normal report.
           And, it is   ON for results of WITH clause number: 1 2 3 4 5 6 7 8 9.
     [SET] UNDERLINE         = OFF ALL
     [SET] WIDTH             = 75

    Example  

    To reset the BTEQ format commands to their default values, enter the following command:

       .SET DEFAULTS

    Example  

    To have a Teradata SQL macro issue the DEFAULTS command, embed it within the string portion of an SQL ECHO statement as follows:

       ECHO '.SET DEFAULTS';