This chapter contains the following topics:
To view the data in tables in different databases, use the Universal Table Browser. This tool lets you verify the existence of data in a table, as well as determine the structure of the table. The Universal Table Browser uses JDEBASE APIs to retrieve data from the database, making it independent of the database that you access.
You can determine whether the data that the Universal Table Browser displays is formatted or non-formatted.
For formatted data, the Universal Table Browser displays the data according to the specifications of the JD Edwards EnterpriseOne data dictionary item. For example, assume that the data item PROC is a numeric field of size 15, with four display decimals. For a value of 56.2185, the Universal Table Browser displays a formatted value (using the data dictionary editing) as 56.2185, even though this value is stored in the database as 562185.
For non-formatted data, the Universal Table Browser displays the data according to the specification of the database and the data item type (such as numeric) from which the data came. For example, assume that the table data item PROC is a numeric field stored in the database. Depending on the database, this field might have a default value size of 32, with a precision of 15 being a numeric data type. Because JD Edwards EnterpriseOne does not store the decimals in the database, a value 56.2185 is stored and displayed in the database as 562185.000000000000000.
The tables that display in the Universal Table Browser contain the query by example (QBE) feature, which functions as it does in any other JD Edwards EnterpriseOne application. For example, you can enter >50 in the ABAN8 column QBE to display records with an address book number that is greater than 50. You can enter F* in the ABALPH column QBE to display records with an alpha name that begins with the letter F.
In addition, the column sequence and column width features function as in any other JD Edwards EnterpriseOne application. You can rearrange the columns. For example, you might want to move a column that you use often from the end to the beginning, or move a column next to an associated column. You also can size columns.
This section discusses how to:
View the data in tables.
View column properties in a table.
Access the Universal Table Browser. In Solution Explorer, select the Cross Application Development Tools (GH902) menu, Object Management, Universal Table Browser.
Note:All column and row security that you set up using Security Workbench applies to the Universal Table Browser.
On Universal Table Browser, select Open Table from the File menu.
On the Table and Data Source Selection form, in the Table field, click the search button to select a table.
In the Data Source field, click the search button to select a valid data source in which the table resides. This default value is obtained from the Object Configuration Manager (OCM) settings in the current environment.
Select the Format Data option if you want the program to display formatted data.
On Universal Table Browser, view a table as described in the previous task.
Right-click a column and select Column Properties.
If you are viewing a formatted table, the data dictionary properties are displayed in the upper-right portion of the Column Properties form. If you are viewing an unformatted table, the data dictionary properties are not displayed.