ECHO - Teradata Database

Returns a fixed character string to the requestor.

where:

Syntax Element …	Specifies …
‘string’	the text to be returned to the requestor.
‘command’	a BTEQ format command to be returned to the requestor. The format command must be terminated by a semicolon.

ECHO is a Teradata extension to the ANSI SQL:2011 standard.

None.

The Teradata preprocessor does not support ECHO.

SQL procedures do not support ECHO.

When the system encounters an ECHO request, it sends an ECHO parcel containing string to the client system, where it is then interpreted.

ECHO is used most frequently in macros to perform BTEQ commands during macro execution.

ECHO cannot be used with the following BTEQ commands.

=

EXPORT

IMPORT

LOGOFF

LOGON

QUIT

REPEAT

RUN

If command is not a BTEQ format command, BTEQ logs the illegal command as an error.

The following ECHO request could be used in a macro that creates a report through BTEQ. When the system encounters the request during macro execution, the width of a printed page is set to 72 characters.

     ... ECHO 'SET WIDTH 72;'...