Purpose
Causes BTEQ to pause for a specified period of time. For Mainframe BTEQ, only batch mode jobs can be paused. For Workstation BTEQ, both interactive and batch mode can be paused.
Syntax
where the following is true:
- n
- The amount of time, in seconds, to pause the BTEQ job.
The range of n is 0 to 2147483647. If no numeric argument is specified, BTEQ pauses for 360 seconds (6 minutes).
Usage Notes
The HANG command is valid in a Teradata SQL macro.
Example 1 – HANG
To specify a half-minute pause, type:
.HANG 30
Example 2 – HANG instigated by a macro
The HANG command in a Teradata SQL macro appears as:
ECHO '.HANG 30';