16.20 - hold - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
April 2020
Content Type
Programming Reference
Publication ID
English (United States)


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.


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.