Purpose
Resets the following types of BTEQ command settings to the original value they had when BTEQ was first invoked:
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';