Available Commands for Teradata SQL Macros - Basic Teradata Query - 16.20

Basic Teradata Query Reference

prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K
BTEQ Commands for Teradata SQL Macros 
BTEQ Command Available for Teradata SQL Macro
AUTOKEYRETRIEVE Yes
COMPILE No
DECIMALDIGITS Yes
DEFAULTS Yes
ECHOREQ No
ENCRYPTION Yes
ERRORLEVEL Yes
ERROROUT Yes
EXIT No
EXPORT No
EXPORTEJECT Yes
FOLDLINE Yes
FOOTING Yes
FORMAT Yes
FORMCHAR Yes
FULLYEAR Yes
GOTO No
HANG Yes
HEADING Yes
HELP BTEQ Yes
IF...THEN... Yes
IMPORT No
INDICATORMODE Yes
LABEL No*
LARGEDATAMODE Yes
LOGDATA No
LOGMECH No
LOGOFF No
LOGON No
LOGONPROMPT Yes
MAXERROR Yes
NOTIFY No
NULL Yes
OMIT Yes
OS Yes
PACK Yes
PAGEBREAK Yes
PAGELENGTH Yes
QUIET Yes
QUIT No
RECORDLENGTH Yes
RECORDMODE Yes
REMARK Yes
REPEAT No
REPEATSTOP Yes
REPORTALIGN Yes
RETCANCEL Yes
RETLIMIT Yes
RETRY Yes
RTITLE Yes
RUN No
SEPARATOR Yes
SESSION CHARSET Yes
SESSION RESPBUFLEN Yes
SESSION SQLFLAG No*
SESSION TRANSACTION No*
SESSION TWORESPBUFS Yes
SESSIONS No*
SHOW Yes
SHOW CONTROLS Yes
SHOW ERRORMAP Yes
SHOW VERSIONS Yes
SIDETITLES Yes
SKIPDOUBLE Yes
SKIPLINE Yes
SUPPRESS Yes
TDP Yes
TIMEMSG Yes
TITLEDASHES Yes
TMSMMSG No
TRAILINGLINES Yes
TRANSLATECTRLSTOSPACES Yes
TRIMTRAILINGSPACES Yes
TSO Yes
UNDERLINE Yes
WIDTH Yes
= No
* Although it is possible to ECHO this command, the command fails as a result of other constraints. For example, all sessions must be logged off to use the SESSION command.