Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

Exporting data

Use the following procedure to export data in .csv format to the location that you chose. The output includes the column headings.

To export data

New console
  1. Select or create a Db2 object view that contains the object or objects that you want to export.For more information, see Creating-a-Db2-object-view.
  2. Navigate to and select your source object or objects.For more information, see Navigating-to-an-object.
  3. Perform one of the following actions:
    • To export all objects in the view, right-click anywhere in the results pane and select Select All; then right-click again and select Export data.
    • To export specific objects, select one or more object entries, right-click, and select Export Data.
  4. When prompted, select a location for the exported data.The default file name is export_data.csv.
  5. Save the file.
Classic console
  1. Select or create a Db2 object view that contains the object or objects that you want to export.For more information, see Creating-a-Db2-object-view.
  2. Navigate to and select your source object or objects.For more information, see Navigating-to-an-object.
  3. Perform one of the following actions:
    • To export all objects in the view, right-click anywhere in the results pane and select Select All g_gud_SelectAll-16.png; then right-click again and select Export data g_gud_export-24.png.
    • To export specific objects, select one or more object entries, right-click, and select Export Data g_gud_export-24.png.
  4. When prompted, select a location for the exported data.The default file name is export_data.csv.
  5. Save the file.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*