Available BTEQ Commands for SQL Macros | Basic Teradata Query - Available Commands for SQL Macros - Basic Teradata Query

Basic Teradata® Query Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-04-02
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
Product Category
Teradata Tools and Utilities
BTEQ Command Available for SQL Macro
AUTOKEYRETRIEVE Yes
BRANCHMSG Yes
COMPILE No
CONNECTSTRING No
DECIMALDIGITS Yes
DEFAULTS Yes
ECHOREQ No
ECHOEXPANDEDREQ Yes
ENCRYPTION Yes
ERRORLEVEL Yes
ERRORONDBSWARNING Yes
ERROROUT Yes
EXIT No
EXITONDELAY No
EXPORT No
EXPORTEJECT Yes
FOLDLINE Yes
FOOTING Yes
FORMAT Yes
FORMCHAR Yes
FULLYEAR Yes
GOTO No
HANG Yes
HEADING Yes
HELP Yes
IF...THEN... Yes
IMPORT No
INDICATORMODE Yes
LABEL No*
LARGEDATAMODE Yes
LOGDATA No
LOGMECH No
LOGOFF No
LOGON No
LOGONPROMPT Yes
MAXERROR Yes
MESSAGEOUT 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
STATEMENTINDEPENDENCE No
SUPPRESS Yes
TDP Yes
TIMEMSG Yes
TIMEOUT No
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.