The Table details page includes the following table information:
Table name
The SQL name of the table.Schema
The schema where the table is to reside.System table name
The system or short name of the table. You can enter a name or allow the system to create a name.Record format name
Specifies the record format name of the table. The record format name is an unqualified name that designates the i5/OS record format name of the table. If you do not specify a record format name, the system will use the same as the System table name. This field is only available when connecting to a V5R4 system or higher.Volatile
Check this to indicate that your table data is volatile, or changes often. When the optimizer finds a table that is defined as volatile, it will be more likely to use an index for access to the table. Statistics for this table are not refreshed as often by the system.Text
A description of the table.
All of these fields can be changed on a new table. However, once the table is created, all of the fields except Text become read-only.
To view the SQL used to build the table, click Show SQL. Once the table is created, Show SQL is unavailable unless a change is made.