HANG
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:
Syntax Element |
Description |
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
To specify a half-minute pause, type:
.HANG 30
Example
The HANG command in a Teradata SQL macro appears as:
ECHO '.HANG 30';