Anchored data type - IBM DB2 9.7 for Linux, UNIX, and Windows

Features of the anchored data type
An anchored type defines a data type based on another SQL object such as a column, global variable, SQL variable, SQL parameter, or the row of a table or view.

Restrictions on the anchored data type
Review the restrictions on the use of the anchored data type before declaring variables of this type or when troubleshooting problems related to their use.

Anchored data type variables
An anchored variable is a local variable or parameter with a data type that is an anchored data type.

Declaring local variables of the anchored data type
Declaring local variables or parameters of the anchored data type is a task that you would perform whenever it is necessary that the data type of the variable or parameter remain consistent with the data type of the object to which it is anchored.

Examples: Anchored data type use
Examples of anchored data type use can be useful as a reference when using this data type.