Exporting a Function/Procedure DDL

Follow the steps below to export the function/procedure DDL:

1. In the Object Browser pane, right-click the selected function/procedure and select Export DDL.

   The Data Studio Security Disclaimer dialog box is displayed.

2. Click OK.

   The Save As dialog box is displayed.

3. In the Save As dialog box, select the location to save the DDL and click Save. The status bar displays the progress of the operation.
   

   • To cancel the export operation, double-click the status to open the Progress View tab and click . For details, see Canceling the Table Data Export Operation.
   • The exported file name will not be the same as function/procedure name, if the function/procedure name contains characters which are not supported by Windows.
   • MS Visual C runtime file (msvcrt100.dll) is required to complete this operation. For details, see Troubleshooting.
   • Multiple objects can be selected to export DDL. Refer to Batch Export section for list of objects not supported for export DDL operation.

   The Export message and status bar displays the status of the completed operation.

   Database Encoding	File Encoding	Support for DDL Export
   UTF-8	UTF-8	Yes
   	GBK	Yes
   	LATIN1	Yes
   GBK	GBK	Yes
   	UTF-8	Yes
   	LATIN1	No
   LATIN1	LATIN1	Yes
   	GBK	No
   	UTF-8	Yes