Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Manage Rowid Column-based Master Keys

A rowid column is a column in a view that references the rowid column of a driving table in the view. Thus, the rowid column in the view contains the unique storage addresses of the rows in the table. A master key that is based on a rowid column is called a rowid column-based master key. A view can have only one rowid column-based master key, and it is named according to the Z$<view label> nomenclature. When you add a rowid column-based master key to a view, a column with the Z$ prefix will be added to the view. Rowid column-based master keys can be defined for the standard, Cross Operations Extension (XOP), and global forms of the views.

You can add, edit, suppress, or delete a custom master key that is based on a rowid column. Noetix-defined master keys based on rowid columns can be edited or suppressed but not deleted.

The following topics describe the procedures related to managing rowid column-based master keys:

Published:

Manage Rowid Column-based Master Keys

A rowid column is a column in a view that references the rowid column of a driving table in the view. Thus, the rowid column in the view contains the unique storage addresses of the rows in the table. A master key that is based on a rowid column is called a rowid column-based master key. A view can have only one rowid column-based master key, and it is named according to the Z$<view label> nomenclature. When you add a rowid column-based master key to a view, a column with the Z$ prefix will be added to the view. Rowid column-based master keys can be defined for the standard, Cross Operations Extension (XOP), and global forms of the views.

You can add, edit, suppress, or delete a custom master key that is based on a rowid column. Noetix-defined master keys based on rowid columns can be edited or suppressed but not deleted.

The following topics describe the procedures related to managing rowid column-based master keys:

For an optimal Community experience, Please view on Desktop