Edit Data

You can edit the data from the browse results.

Procedure

  1. Click the Edit button to edit data. In order to edit data directly in the database, you need security keys and instructions on how to update data. Please contact your IBM® Controller representative. The Enter Keys for Write Access to Browse Data dialog box opens.
  2. Enter the security keys and click OK. Now you can edit, delete, add new rows and export the data. Click Save and Close.

Results

  • The export function in Browse data is normally used for Controller support purposes. If you want to export and import structures and data within your group, use the Export Structures or Export Data functions. For more information, see Export and Import of Structures and Data.
  • All test values should be included within single quotation marks (') and if you use the test operators IN or NOT IN, the test values should be included in parentheses.

Tip: When you define search criteria for limiting the browse result you can use wild cards, which represent zero or more characters.

In an SQL environment you can use the following wild cards:

Table 1. Wild cards that you can use in an SQL environment
% Represents a string of zero or more characters
_ (underscore) - Represents one character
[] Represents one character within the specified range, for example [a-f]
[^] Represents one character not within the specified range, for example [^a-f]