Create Index: Partition Values panel
You use the Create Index: Partition Values panel to specify limit values for index entries in each partition.
Panel and field definitions
Process Options Utilities Help
FM/Db2 (DFG2) Create Index: Partition Values Row 1 to 6 of 6
New Index:
Owner . . . . . . . +
Name . . . . . . . FRED +
Table owner . . . . FMNUSER +
Table name . . . . EMP +
Parttn.
Number Column Name Value +
1 EMPNO
FIRSTNME
MIDINIT
2 EMPNO
FIRSTNME
MIDINIT
******************************* Bottom of data ********************************
Command ===> Scroll PAGE
F1=Help F2=Split F3=Exit F4=Expand F7=Backward F8=Forward
F9=Swap F10=Left F11=Right F12=Cancel
- Owner
- The name of the owner of the new index.
- Name
- The name of the new index.
- Table owner
- The SQLID used to create the table on which the index is being defined.
- Table name
- The table on which the index is created.
- Parttn. Number
- A sequential number showing the number of partitions defined. This is a display-only field.
- Column Name
- The name of the column.
- Value
- The smallest unit of data that is manipulated in SQL.
Parent panels
Child panels
None.