16.20 - scope - 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

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.