16.20 - join - 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 joins a UDF to a debugging session.

Syntax

join sessno[/udfname] [ wait ]
sessno
The session number of the UDF to be debugged. This is typically taken from the output of a prior info udf command, but UDFs can be joined without a prior info udf command if the user already knows the number for the session to debug.
udfname
The name of a UDF waiting to be debugged. This is optional.
wait
The optional wait parameter requests that this command not complete until there is at least one UDF available to debug.

Joining a session number without specifying udfname joins any UDF debugged by that session. Joining a specific udfname only joins that UDF.

Usage Notes

At least one UDF that matches the join criteria must be waiting to be debugged when the command is entered. However, once joined, all current and future instances of the named UDF (or all UDFs) from the specified session are caught by this debugging session.

Multiple join commands can be issued to debug multiple UDFs, or even multiple database sessions. Once something is joined, though, it can only be unjoined by terminating the debugger session. Anything joined to one debugger session cannot be joined to another one until you exit the first session.