scope Command | Command-line Debugging for UDFs | Teradata Vantage - scope - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

This command selects the UDF instances that will have breakpoints installed when the UDFs are continued.

Syntax

scope all
scope thread-selectors [...]

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

The default, scope 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.