scope Command | Command-line Debugging for UDFs | Teradata Vantage - 17.10 - scope - 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 selects the UDF instances that will have breakpoints installed when the UDFs are continued.

Syntax

scope all
scope { thread-selector [...] | all }

Syntax Elements

thread-selector
Specifies a string that selects one or more UDF threads being debugged.
Default: all (applies breakpoints to all instances)

Usage Notes

Note that breakpoint scope applies only for the duration of the UDF invocation for which it is set. When a UDF in scope exits, it is removed from the scope. If all of the UDFs in scope exit, then the scope is reset to all.

New UDFs with the same thread selectors do not inherit the scope that was set previously. To limit breakpoints to specific UDFs, it may work better to hold off running multiple UDFs than to set scope to the one of interest.