Copy a SQL Stored Procedure XML | Example | Teradata Data Mover - Example: Job Request XML for Copying a SQL Stored Procedure - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.00
Published
November 30, 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
gmn1574692806523.ditamap
dita:ditavalPath
cjo1509024828169.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

An XML snippet for copying a SQL stored procedure is shown below:

<dmCreate> 
...
<database selection="unselected">
 <name>database1</name>
 <table selection="included">
  <name>test</name>
 </table>
</database>

<stored_procedures>
 <stored_procedure selection="included">
  <name>macro1</name>  
  <database>database1</database>
 </stored_procedure> 
</stored_procedures>
...
</dmCreate>