16.20 - hold - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

Purpose

You can use the hold command to control which UDFs run when continue commands are entered. Threads that are held will not execute; all others will execute.

Syntax

hold all
hold thread-selectors [...]

Where syntax element thread-selectors specifies a string that selects one or more UDF threads being debugged.

Usage Notes

You can use hold and unhold together. For example, you could use hold all and then unhold just the thread you want to execute.

hold affects only the continue command; the step and next commands implicitly hold all threads except the current one.