Available Commands for Teradata SQL Macros - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.00
Published
November 2016
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
hyz1479325149183.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities
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
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.