The Indexes Panel (SQLIO)
Within a Sunbelt SQLIO Schema database a required table named "sun_sqlio_ifile" must exist. The SchemaEditor exposes this table using the Indexes panel. This table contains the schema information that associates a PLB program IFILE file reference to a SQL data table name. In addition, this table contains the IFILE key information that allows the runtime to identify the SQL data table columns associated with the key information. The columns defined for this system table are:
|
Column |
Use |
|
id |
This column is a unique number that identifies an index record layout. The SQL data type for this column is 'integer primary key'. |
|
name |
This column contains contains the PLB ISI file name as specified in a PLB OPEN instruction. |
|
index_name |
This column contains the SQL object name used in a CREATE INDEX SQL statement. If not provided, the default will be the value from the name column with the 4 characters '.', '/', '\', and ':' converted to the '_' character. |
|
file_name |
This column that identifies the TXT file name associated with the ISI file. The data in this column is used to look up information contained in the 'SUN_SQLIO_FILE' system table. |
|
key_info |
This SQL text column that contains one or more comma separated column names for an associated table. |
|
unique_idx |
This integer column that specifies whether the index key column or combined columns for the key make a unique value. A value of zero indicates that the key is not unique. A value of one is unique. |
|
upper_case |
This integer column that specifies case sensitivity when matching keys. A value of zero is case sensitive. A value of one is case insensitive. |
|
no_create |
This integer column that indicates if a CREATE INDEX SQL statement should be executed on a PL/B PREPARE. A value of zero indicates that it should be executed, and a value of one indicates that it should not be executed. Note: Depending on the operations of the SQL database, it may be more performant to not have a SQL INDEX on smaller SQL TABLES. The 'no_create' column provides a means of optionally eliminating a SQL INDEX for some scenarios. |
|
description |
This text column for user information as desired. |
Index Addition or Edit
To add a index to the database, select "Add" from the Indexes menu or right click on the Index panel and choose "Add". The Index Editor will then be displayed
Edit Index
The Edit Index function allows the user to alter an index's parameters. Once selected, the above dialog appears.
Delete Index
The Delete Index function removes the index from the schema database. The Delete functions within the SchemaEditor utility all support multiple selection.
 |