Changing Table and View Data

You can use the IBM^® Data Designer to review the data in IBM database tables or views, and then change the data by updating or deleting existing data or by adding new data.

To change the data in a table or view:

In the Server Explorer under your IBM data connection, right-click the table or view that you want to change, and then select Show Data on the shortcut menu.
The IBM Data Designer opens.
To update the data in an existing row of the table, for each cell that contains a value that you want to update, click the cell and then type the new value.
If the cell contains XML data, after you click the cell, click the down arrow, and then select XML Designer on the drop-down menu. Use the DB2 XML Designer to change the XML elements or text.
To delete an existing row, click any cell in the row, and then press Delete.
To add a row of data:
1. Click a cell in the last row of the table.
  The designer inserts a blank row immediately before the last row.
2. Type data in the cells of the new row.
  For a column of XML data, click the cell, click the down arrow, and then select XML Designer on the drop-down menu. Use the DB2 XML Designer to enter the XML elements and text for the column.
3. Optional: To add another blank row, press Enter or press the Down Arrow key.
Save the data. From the File menu, select Save Data.

See Also