Copy a SQL Stored Procedure with Underlying Table | Example | Teradata Data Mover - Example: Job Request XML for Copying a SQL Stored Procedure With its Underlying Table - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Published
October 2021
Language
English (United States)
Last Update
2021-10-14
dita:mapPath
cai1626458602965.ditamap
dita:ditavalPath
cai1626458602965.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
An XML snippet for copying a SQL stored procedure with its underlying table is shown below:
<dmCreate>
...
<database selection="unselected">
	<name>database1</name>
	<table selection="included">
		<name>test</name>
		<validate_row_count>all</validate_row_count>
	</table>
</database>
<stored_procedures>
	<stored_procedure selection="included"> 
		<name>sp_test</name>  
		<database>database1</database> 
	</stored_procedure> 
</stored_procedures>
...
</dmCreate>