Enhanced Stored Procedure | Teradata Business Continuity Manager - Enhanced Stored Procedure - Teradata Business Continuity Manager

Teradata® Business Continuity Manager User Guide - 1.01.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Business Continuity Manager
Release Number
1.01.01
Published
March 2023
Language
English (United States)
Last Update
2023-03-13
dita:mapPath
qra1653979755546.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2550
lifecycle
previous
Product Category
Analytical Ecosystem

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

Each statement from the SP body is sent to Business Continuity Manager for replication, lifting all traditional Business Continuity Manager SP limitations. This allows Business Continuity Manager to support SP containing dynamic SQL, conditional execution patch, multiple DDL, multiple transactions, and so on.