Show TOC

Procedure documentationWorking with the Open SQL Data Browser Locate this document in the navigation structure

 

The Open SQL Data Browser is a tool for viewing the content of database tables residing in the system database schema.

Using the Open SQL Data Browser, you can display all data from the table of interest. You can change the set of the columns that are displayed. To restrict the amount of data, you can define search conditions.

The Open SQL Data Browser offers two data access methods — specifying table and column predicates, and specifying SELECT statements.

Prerequisites

You are in the   Problem Management   Database   Open SQL Data Browser   function of the SAP NetWeaver Administrator.

Procedure

Displaying Data Using Table and Column Predicates
  1. Select Specify a table and optional column predicates from the Data Access Method dropdown list.

  2. Enter a valid table name in the Show field, then choose the Go pushbutton..

    You can also search for a particular table:

    1. Choose the Search (Search) pushbutton.

    2. Using wildcards, enter a search string in the Table name field, then choose the Go pushbutton.

    3. In the result list, select the table of interest.

    The Open SQL Data Browser displays the content of the selected table.

  3. To display in details the content of a particular row, select the row.

  4. To include or exclude particular columns from the table view, choose Column List, then select or deselect the desired columns, and choose Go.

  5. To change the maximum number of the displayed entries, type a value in the Maximal Number of Hits field, then choose the Go pushbutton.

Specifying Search Conditions

You can restrict the table rows by defining predicates on the table columns.

  1. Choose the Search Condition pushbutton.

  2. Select the Create New Predicate radio button.

  3. Specify the predicate arguments using the Column, Predicate Type and Value fields.

  4. Choose the Add pushbutton.

    The new search condition predicate appears in the Predicates table.

  5. If necessary, add more predicates.

  6. To edit/remove a predicate:

    1. Select the predicate.

    2. Select the Update/Remove selected Predicate radio button.

    3. To edit the arguments of the predicate, specify the desired values, using the Value field, then choose the Update pushbutton.

    4. To remove the predicate, choose Remove.

  7. To see the number of entries that meet the search condition, choose Number of Entries.

  8. To display the filtered table content, choose Go.

Displaying Data Using SELECT Statements
  1. Select Specify a SELECT statement. from the Data Access Method dropdown list.

  2. Type the SELECT statement in the Show field, then choose the Go pushbutton.

    For more information, see SELECT Statement

  3. To display in details the content of a particular row in the result list, select the row.

Changing the Settings of the Open SQL Data Browser
  1. Choose the Settings pushbutton.

  2. You can change the following types of settings:

    • Data Truncation — specify how the read data should be handled

    • Result Display — customize the layout of the displayed result

    • Detailed Result Display — customize the layout of the displayed detailed result

    • Open SQL for Java related settings