Purpose
This command causes BTEQ to pause for a specified period.
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 an 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 an SQL macro appears as:
ECHO '.HANG 30';