info held Command | Command-line Debugging for UDFs | Teradata Vantage - 17.10 - info held - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

This command displays the current hold status. If no threads are held then no status is returned.

Syntax

info held [ long ]

Syntax Elements

long
Appends a list of threads that are being held from execution.

Examples: Using the info held Command

This example shows using info held after hold all and the difference between info held and info held long:

(gdb) hold all
(gdb) i held
all
(gdb) i held long
all ->   1//6441  0//6457

This example shows using info held after a hold of specific threads:

(gdb) hold 1//6441  0//6457
(gdb) i held
( 1//6441 0//6457 )
(gdb) i held long
( 1//6441 0//6457 ) ->   1//6441  0//6457

When changes to a hold are made using the unhold command, info held long displays the original hold command parameters followed by a minus sign and a list of released threads. It also displays the resulting threads that are still held.

(gdb) hold 1//6441  0//6457
(gdb) i held long
( 1//6441 0//6457 ) ->   1//6441  0//6457
(gdb) unhold 0//6457
(gdb) i held long
( 1//6441 0//6457 ) - ( 0//6457 ) ->   1//6441