Enhanced Stored Procedure | Teradata Unity - 17.00 - Enhanced Stored Procedure - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval

When a stored procedure (SP) call is made through Unity with CDM enabled, Unity uses enhanced SP handling for that SP call. With enhanced SP handling, the database engine forwards each statement from the SP body to Unity, and Unity SQL replicates or CDM replicates each statement.

Each individual statement from the SP body is sent to Unity for replication purpose, lifting all traditional Unity SP limitations. This allows Unity to support SP containing dynamic SQL, conditional execution patch, multiple DDL, multiple transaction, and so on.