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.