Purpose
This control enables users to specify whether an expanded version of the input instruction should be printed for interactive mode, after it has been processed and acted upon, and the instruction contained any shorthand syntax.
Syntax
| Command | Shorthand |
|---|---|
| ECHOEXPANDEDREQ | EER |
Usage Notes
The ECHOEXPANDEDREQ command can be used in interactive mode to have BTEQ display the expanded input instruction text, in case it contained a shorthand syntax for any BTEQ command or its options. This command cannot be used in batch mode or when using a RUN file. The initial default is ON and BTEQ assumes ON if no argument is specified. This command can be used in an SQL macro.
BTEQ does not echo the password portion of the LOGON command.
Example – ECHOEXPANDEDREQ
Interactive Mode
BTEQ -- Enter your SQL request or BTEQ command: .SET ECHOEXPANDEDREQ ON .SET ECHOEXPANDEDREQ ON BTEQ -- Enter your SQL request or BTEQ command: .SH C EER .SH C EER [SET] ECHOEXPANDEDREQ = ON *** Expanded Request Text: .SHOW CONTROLS ECHOEXPANDEDREQ BTEQ -- Enter your SQL request or BTEQ command:
Batch Mode
+---------+---------+---------+---------+---------+---------+---------+----
.SET ECHOEXPANDEDREQ ON
*** Error: ECHOEXPANDEDREQ command use is only valid for interactive
mode and when not reading from RUN file.
+---------+---------+---------+---------+---------+---------+---------+----