The export operation for execution plans stores the information in an internal Teradata Visual Explain format (.mcf file), as opposed to a text file containing SQL statements that could be executed using BTEQ.
Before exporting execution plans, go to “Exporting QCD Data to a File” on page 109 and perform step 1 through step 4 of the procedure.
1 In the Export QCD dialog box, ensure that Execution Plans is selected (default setting).
2 Click Export.
The Save As dialog box appears.
3 To save the QCD information:
a Enter a name for the file in the File name box.
b Click Save.
Note: If an existing .mcf file is selected, a message appears indicating the file already exists. Click Yes to replace the existing file or click No to return to the Save As dialog box and enter a new file name.
The Select Execution Plan(s) to Export dialog box appears.
Figure 29: Select Execution Plan(s) to Export4 Click Browse QCD.
The execution plans load.
5 [Optional] To see complete statement text information:
a Select a statement.
b Click .
For more information on the Statement Text dialog box, see “Viewing Statement Text” on page 80.
Note: To browse XML plans, select the QCD XML Plans check box and click the Browse button.
6 Select the plans to export.
7 Click Export.
A progress message appears. When the export is complete, the Control Center dialog box appears.
Note: To stop the export action immediately, click Abort. A message appears indicating the export action has been canceled.