Exporting Result Data from Procedures and Functions

With the IBM^® Database Add-Ins for Visual Studio, you can export to a file the data that results from running a procedure or function. You can specify one of the three following file types for the exported data:

XML - XML result file
CSV - comma-delimited file
PSV - pipe-delimited file

If the result data that you want to export contains one or more columns of XML data, the export file type that you select determines how the data is exported.

XML - cells of XML data are included in the XML result file.
CSV - each cell of XML data is exported to a separate XML file. The name of each XML file is the base name of the CSV file with an incremental number, the CSV extension, followed by an XML extension. For example, if the name of the exported CSV file is exportdata.csv, the names of the accompanying XML files are exportddata1.csv.xml, exportdata2.csv.xml, exportdata3.csv.xml, and so on.
PSV - each cell of XML data is exported to a separate XML file. The name of each XML file is the base name of the CSV file with an incremental number, the CSV extension, followed by an XML extension.

After you export the result data to a file, you can use the data in an external application.

Requirement: The procedure or function whose result data you want to export must be run, and the result data must be displayed in the IBM Data Designer. For detailed steps on this process, see Running Procedures or Functions.

To export the data that results from running a procedure or function:

In the Data view of the IBM Data Designer, click Export.
In the Save As window, specify the directory in which you want to save the file, type a name for the file, select the file type, and then click Save.
The data that is displayed in the Result Data section of the Data view is saved in the directory and file that you specified, with the format that you selected.

See Also