Example: Exporting Data Area's Data to a Directory in CSV Format

To export all the data in the gen data area to CSV files in a directory DataOut, type the following at a command line:

dbexport -o /usr/user123/DataOut -C gen

The screen output will look like the output in the example, Example: Exporting Data Area's Data to a Directory in Binary Format.

In the DataOut directory, you will find a set of files with the names listed by dbexport as it exported data. The file contents are in CSV format, and may be viewed and edited with a text editor or a program like MicroSoft Excel, or loaded into a database using dbimport.

The default CSV export configuration places a header record at the beginning of the file, and uses a comma as the field separator.

This example shows a CSV export of the Role business class.

UniqueID,Role,Description
43b2e8a5-0001-0010-0000-000a438f7b02,Admin,System Administrator          
43b2e8a5-0001-0010-0000-0019438f7b02,Dev,Developer