15.00 - Unity Director Support for SQL Procedures - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

Unity Director Support for SQL Procedures

Unity Director sends request-specific context information as part of a request that calls an SQL procedure to enable Teradata Database to change the result of the procedure indirectly by substituting a value predefined by Unity Director for a non‑deterministic result. Teradata Database makes this context information available to the SQL statements embedded within a procedure when it is called from the default connection for the session.

However, SQL procedures can generate and use their own arbitrary non‑deterministic values that Teradata Database has no knowledge of. Therefore, Teradata Database cannot guarantee that an SQL procedure call produces a consistent result in a Unity Director environment.