When you make duplicate column entries in a column that has the Key option selected in the Column Information window, you see this message:
Duplicates found. Column[column_name] unique property removed.
This means that TRAN-IDE unselected the Key option for the column that contains duplicates. Click OK.
When you make duplicate entries in a column that does not have the Key option selected, but then edit the column and select the Key option, you see this message:
Col[column_name] has [#] duplicate[entry]. Edit duplicates now?
Select OK to open the Edit Duplicates window. If you click Cancel, TRAN-IDE unselects Key in the Column Information window.
When you edit duplicate keys, complete these options:
Item |
Description |
|---|---|
Column Name |
Displays the column name. You cannot edit this information. |
Row and Duplicate Value |
Displays the duplicate column values.
Highlight the row containing the data you want to change, then use the Value field to edit the data. |
Value |
Displays the data in the highlighted row. Type a new value in the field. |
When you finish, click Done to save the changes and close the window.
If a column has duplicate entries and the column is
marked as a search (key) column in a filter or qualification object,
the SFM performs a linear search of the table, otherwise, it performs
a binary search, which takes less time.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
