BTEQ - Default in Teradata

It will reset BTEQ command options to the values that were set when BTEQ was first invoked.

To reset the BTEQ format commands to their default values, enter the DEFAULTS command as follows:
.SET DEFAULTS


.LOGON  tdid/user, pass;
.SET DEFAULTS;


Once you execute the Default command, the following parameters will be reset.
Please refer the table below.

CommandValue
ECHOREQON
EXPORTRESET
FOLDLINEOFF ALL
FOOTINGNULL
FORMATOFF ON
FORMCHAROFF
HEADINGNULL
INDICDATAOFF
LOGONPROMPTON
OMITOFF ALL
PAGEBREAKOFF ALL
PAGELENGTH55
QUIETOFF
RECORDMODEOFF
RETCANCELOFF
RETLIMITNo limit
RETRYON
SKIPDOUBLEOFF ALL
SKIPLINEOFF ALL
SUPPRESSOFF ALL
TITLEDASHESON
UNDERLINEOFF ALL
WIDTH75 characters.