Starting the Table Editor in CHANGE mode

When you are in CHANGE mode in the Table Editor you can change the data in a table.

Before you begin

Make sure the text case (UPPER, STRING, or MIXED) that you specify with the CASE parameter in your QMF profile is the same for this session as the text in the table. A MIXED value for the CASE parameter might have implications in TSO for the QMF CONNECT command.

About this task

If a table contains CLOB or DBCLOB columns, those columns cannot be edited. Also, only up to 32 K of CLOB data and up to 16 K of DBCLOB data is displayed.

Procedure

To make changes to the data in a table, do one of the following, depending on where you are starting:

From the QMF home panel, type:
```
tablename (MODE=CHANGE
```
Then press the Edit Table function key.
From any other QMF panel with a command line, enter:
```
EDIT TABLE tablename (MODE=CHANGE
```

Results

The Table Editor SEARCH panel displays so that you can search for the first row you want to change.

Example

For example, to change rows in the PERS table, enter the following on the QMF command line:

EDIT TABLE PERS (MODE=CHANGE

To enter the same command and save each addition as you make it, enter:

EDIT TABLE PERS (MODE=CHANGE SAVE=IMMEDIATE