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.
To view or alter data in a table:
- Select the table in the left panel.
- Select the Data tab in the right panel.
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.
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.
- 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).
- 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.
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.
To inspect a Java object within the table, choose it and click the Inspect icon (see Inspecting Java Objects).
Version 5.2
[prev] | [next]