HANG - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
wmy1488824663431.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

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