HANG Command | Basic Teradata Query - HANG - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

Causes BTEQ to pause for a specified period of time.

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';