ALTER CUSTOM VIEW

Purpose

Alter a custom view column in a custom view of the specified source.

Syntax

ALTER CUSTOM VIEW <source system name>"."<custom view name>
(
  ( ADD COLUMN <column name> <type> [IS [NOT] IGNORED] <business definition>)
| ( MODIFY COLUMN <column name> +([<type>] [IS [NOT] IGNORED] [<business definition>] [RESET BUSINESS NAME] [REMOVE BUSINESS OBJECTS])
| ( DROP COLUMN <column name>)
| ( RENAME COLUMN <old column name> TO <new column name>)
| ( SET LOCATION <location>)
| ( USES "(" <business object>"."<business attribute> [{"," <business object>"."<business attribute>}] ")" )
";"
 
<type> = <technical data type> ["(" <precision> ["," <scale> ")"]]
 
<business definition> =
[AS <business name>]
[IS [NOT] INSCRIPTION TIME]
[IS [NOT] KEY]
[IS [NOT] DELETE FLAG]
[(<business object name> | ("(" [<business object name> [{"," <business object name>}]] ")"))]

For an explanation of the syntax notation, see TinML Syntax Notation.

Usage Notes

RESET BUSINESS NAME The business name of the custom view column is overwritten with the business name automatically derived by Yotilla from the source column name.
REMOVE BUSINESS OBJECTS The mapping of the business object to the custom view column is removed.

All other parameters are described in DEFINE CUSTOM VIEW.

Examples

ALTER CUSTOM VIEW "My System"."Product Discount" MODIFY COLUMN "discount_price" [DECIMAL] (15,2);

Expected Result

Custom View "My System"."Product Discount" altered.