Clear data

System i Navigator uses the Clear Physical File Member (CLRPFM) command to clear data from a table.

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with.
  4. Click the Tables container.
  5. Right-click the table that you want to clear data from and select Data -> Clear.