|
|
|
The updateSqlViewColumn element allows an existing column on a SQL view to be modified.
Example:
<updateSqlViewColumn name="title" sqlView="my_SQL_view" >
<description>This is a new description for my sql view column.</description>
</updateSqlViewColumn>
Required Attributes:
Attribute Name |
Description |
|---|---|
name |
Specifies the name of the SQL view column. |
sqlView |
Specifies the name of the SQL view on which this column exists. |
Optional Child Elements:
Element Name |
Description |
|---|---|
dataType |
The data type of the SQL view column. Valid values are:
|
length |
For string columns, the length (in characters) of the column. This is required for string columns. The length can be increased, but cannot be decreased, as this could cause data loss. |
description |
Description of the column and its purpose. |
isSearchable |
For Oracle database systems, indicates if this column should be searchable in a case-insensitive manner or not. |
isUserDefined |
Indicates if this column has been defined by the customer. |
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. |
isCurrencyData |
Indicates if this column holds monetary (currency) data. |
isPredefined |
This attribute is not typically used. |
isComputed |
This attribute is not typically used. |
isMandatory |
This attribute is not typically used. |
isDirect |
This attribute is not typically used. |
See Also |
Next |