View and Export Data for Extract Objects

This scenario shows how a database administrator (DBA) views and exports the contents of an extract object.
carcedb2
This scenario shows how a database administrator views and exports the contents of an extract object in
CA RC/Extract™ for DB2 for z/OS
(CA RC/Extract).
Viewing the data lets you verify file contents before you perform other work (for example, loading the data into a target subsystem). You can search for specific information in the extract object. You can export the data from the extract object into a data set in a readable character format. This activity is useful for performing testing (such as comparing one release to another release).
This illustration describes the tasks to view and export data for extract objects:
The flowchart diagram shows the process steps for viewing and exporting data for extract objects.
This scenario describes the following tasks:
2
2
View Data in an Extract Object
You can view the contents of an extract object file and can perform searches. Browsing the data lets you verify file contents before you perform other work (for example, loading the data into a target subsystem). You can also access statistics that are associated with any find operation.
Follow these steps:
  1. (Optional) Update your profile to customize your viewing session:
    1. Enter
      PROFILE
      in the command line of any product panel.
      The Profile panel appears.
    2. Enter
      2
      in the OPTION field to update the product profile variables.
      A list of parameters appears.
    3. Adjust the maximum column width to display and the maximum number of records to display when viewing data as needed.
      Press the End key until the product Main Menu appears.
  2. Enter
    C
    in the command line on the product Main Menu.
    The Command Center panel appears.
  3. (Optional) Customize the header fields to change results in the list, then press Enter.
    Results change according to your customizations.
  4. Enter
    V
    next to an extract object in the list.
    The Extract Object Contents panel appears.
  5. (Optional) Enter the following command to search for specific data in the extract object:
    Search [
    string
    ]
    • string
      (Optional) Specifies information that you want to locate in the extract object. This action lets you verify or find information without going into the detailed view.
      If you omit a
      string
      , the advanced search panel appears. Use this panel to perform mixed-case text searches, to limit searches to specific objects within the extract object, and to export search data to a specified destination. You can run advanced searches online or in a batch job.
    Message information appears, reflecting search results. To directly view information that you are targeting in your searches, you can view the contents of extract object members.
  6. Enter
    V
    next to an extract object member to view its contents.
    The Extract Object View panel appears. This panel lists members of the extract object.
    Dependent objects are indented under parent objects. You can globally hide or expose dependents by issuing the COLLAPSE (
    C
    ) or EXPLODE (
    E
    ) primary command. You can issue the
    C
    or
    E
    line command to hide or expose dependents on individual lines. If you performed a search for the object, the view is positioned to the first matched string. You can find other occurrences of the string by performing the RFIND command (PF5).
    The panel displays as many records as allowed in the available memory. Large objects might show only a subset of records. Column width is 32 characters by default. If column data exceeds this width, you can place the cursor in the column data and can scroll right and left (PF11 and PF10).
  7. Use the line commands to view and manipulate displayed data.
    Data views change as you issue commands. You can continue to view extract object data and enter commands as needed.
Export the Contents of an Extract Object
You can export data from an extract object into a data set in a readable character format. This activity is useful for performing testing (such as comparing one release to another release).
When exporting the data, you can use the View format (for simply viewing the output) or comma-separated value (CSV) format. CSV file format lets you import the content into other tools that accept this format. In View format, data is formatted and aligned with the columns. In CSV format, fields are separated by commas in the same order as the column record.
You can also export data when viewing the contents of an extract object. After choosing to view the extract object contents from the Command Center, issue the SEARCH primary command. The command provides access to advanced options where you can export search results to a data set.
Follow these steps:
  1. Enter
    C
    in the command line on the product Main Menu.
    The Command Center panel appears.
  2. (Optional) Customize the header fields to change results in the list, then press Enter.
    Results change according to your customizations.
  3. Enter
    O
    next to an extract object in the list.
    The Export Object panel appears.
  4. Complete the fields on the panel to control the export process, and press the END key.
    The product exports data to the data set that you listed in your settings. The export data set contains records from all objects in the extract object. The records for each object are bracketed with the start and end information that identifies the name of the containing object.
Example: Sample Export Data Set
An export data set contains records from objects in an extract object. Each record includes the following information:
  • Bracket information indicating the start of the record
  • Object type and qualified name
  • Extract object internal ID
  • Approximate number of records between the brackets
  • Bracket information indicating the end of the record
Extracted data immediately follows the column record.
This example shows a sample export data set:
{{START T SYSIBM.SYSROUTINES 0001 8600 table_data {{END T SYSIBM.SYSROUTINES