updateViewColumn

The updateViewColumn element allows an existing view column to be modified.

Example:

<!-- change to a new column on the same table -->
<updateViewColumn name="viewColumnName" view="viewName">
   <column>newColumnName</column>
</updateViewColumn>

<!-- change to a new column on a new table -->
<updateViewColumn name="viewColumnName" view="viewName">
   <table>newTableName</table>
   <column>newColumnName</column>
</updateViewColumn>

<!-- change to the same column name on a different table -->
<updateViewColumn name="viewColumnName" view="viewName">
   <table>newTableName</table>
</updateViewColumn>

Required Attributes:

Attribute Name

Description

name

Specifies the name of the view column

view

Specifies the name of the view


Optional Child Elements:

Element Name

Description

table

Specifies the name of the table that this view column comes from

column

Specifies the name of the column on the table that this view column comes from

description

Description of the index and its purpose

alias

If referencing a join that has an alias, the name of the alias.

clarifyGenericFieldID

This data is used by Amdocs/Clarify applications to identify fields in different objects that are handled in a similar way. For example, a WIPbin contains different types of objects, such as cases and bugs. Certain fields in these objects (such as the ID number and title) are treated in the same way by the application and are assigned the same clarifyGenericFieldID.

Note: There is not an isUnique attribute. To indicate a viewColumn as unique, set the clarifyGenericFieldID to 3.

See Also

schemaScript

addColumn

addExclusiveRelationSet

addIndex

addJoin

addRelation

addSqlView

addSqlViewColumn

addTable

addView

addViewColumn

updateColumn

updateIndex

updateJoin

updateRelation

updateTable

updateSchema

updateSqlView

updateSqlViewColumn

updateView

Next

DataDictionary XML Reference

updateViewColumn