Viewing, Inserting, and Modifying Data

Cview lets you browse data in a table. Cview also lets you insert, delete, or modify data of a SQL-J (non-Java-object) data type.

Selecting the Table

To view or alter data in a table:

  1. Select the table in the left panel.
  2. Select the Data tab in the right panel.

Viewing Data

Built-in data type values appear in the table grid on the Data tab. If a column contains a Java object, the object's toString value appears.

NOTE: Cview displays a BIT and BIT VARYING value containing 128 bytes or fewer as a hex string. You can copy the hex string, but you cannot alter it. If the BIT or BIT VARYING value is a gif, it is displayed as an image, otherwise nothing is displayed.

NOTE: When you first view the data in a table, the first 1000 rows are loaded. For tables with more than 1000 rows of data, you can choose to load all rows, or to load rows one thousand at a time. To load all the data in the table, click the "Load all" icon above the results grid. To load only the next 1000 rows, click the "Load next 1000 rows" icon.

Viewing Data in a Different Locale

By default, the Cview locale is the same as your java system locale. You can specify a different Cview session locale by starting Cview with the db2j.ui.locale property. If you have set the locale property to a different locale, you can toggle display of locale-sensitive data between the two locales.

  1. To display dates, timestamps, numbers, and times in the format of the Cview session locale, use the View>Local Data Representation menu option (Cview), or the LocalizedDisplay command (ij).
  2. To return the display of these types to the default Cview locale, click the menu option again to disable it.

NOTE: These options do not change how Cloudscape stores locale-sensitive data, simply how the data is displayed.

For more information about localization, see the Cloudscape Tools and Utilities Guide and the Internationalization appendix in the Cloudscape Developer's Guide.

Insert, Delete, or Modify Data

You can also use a table's Data tab to insert, delete, or modify data of a SQL-J (non-Java-object) data type.

NOTE: Do not attempt to insert or modify values in a column defined as Autoincrement. These values are automatically assigned and incremented by the database.

Inspecting Java Objects in Data

To inspect a Java object within the table, choose it and click the Inspect icon (see Inspecting Java Objects).