HANG - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

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