I/O in UDFs | SQL External Routine Programming | Teradata Vantage - 17.10 - I/O - 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)

The following rules apply to I/O.

IF the UDF … THEN the function …
runs in nonprotected execution mode cannot do any I/O, including standard I/O and network I/O.
specifies the EXTERNAL SECURITY clause in the CREATE FUNCTION or REPLACE FUNCTION statement can do I/O or otherwise interface with the operating system such that the operating system retains resources such as file handles or object handles.

The function executes as a separate process under the authorization of a specific native operating system user established by a CREATE AUTHORIZATION or REPLACE AUTHORIZATION statement.

The function must release opened resources (close handles) before it completes. Table functions must release opened resources before completing the end phase. All other types of functions must release opened resources before each instance of the function terminates.

runs in protected execution mode can do I/O or otherwise interface with the operating system such that the operating system retains resources such as file handles or object handles.

The function executes as a separate process under the authorization of the 'tdatuser' operating system user.

The function must release opened resources (close handles) before it completes. Table functions must release opened resources before completing the end phase. All other types of functions must release opened resources before each instance of the function terminates.

For more information on protected execution mode, see Protected Mode Function Execution.